小弟刚学编程遇到一SQL查询问题 两表结合查询 请大大们帮忙解决

[jackeyaw]

Select u_Name,s_ID,BillSN,BillDate From (Select s_ID as s_ID,BillSN as BillSN,BillDate as BillDate From MasterOrder where BillDate between '2001-00-22' and '2010-00-23'),(Select u_Name as u_Name From Units where s_ID =(Select Unit_ID From MasterOrder where BillDate between '2001-00-22' and '2010-00-23'))

以上是我写的查询语句 报错为：第 1 行: ',' 附近有语法错误
我是为了实现从MasterOrder表里查询出s_ID,BillSN,BillDate 而又以MasterOrder表里的Unit_ID作为条件 查出Units表里的u_Name 最终查到 u_Name,s_ID,BillSN,BillDate 这四个值 同时对MasterOrder的查询是以时间段来进行的 而MasterOrder和Units两个表里同时都有s_ID这个字段
请大大帮忙了 小弟感激不尽 在线等解决

[ForFumm]

Select b.u_Name,a.s_ID,a.BillSN,a.BillDate from MasterOrder a,Units b where a.s_ID=b.s_ID
and a.BillDate bwtween '2001-00-22' and '2010-00-23'

[shadowdudu]

Select u_Name,s_ID,BillSN,BillDate From
(	Select s_ID as s_ID,BillSN as BillSN,BillDate as BillDate From MasterOrder where BillDate between '2001-00-22' and '2010-00-23'
	
union all
Select u_Name as u_Name From Units where s_ID =(Select Unit_ID From MasterOrder where BillDate between '2001-00-22' and '2010-00-23')
)a

难道是这样？？

[「已注销」]

Select N.u_Name,M.s_ID,M.BillSN,M.BillDate From
 (Select s_ID as s_ID,BillSN as BillSN,BillDate as BillDate From MasterOrder where BillDate between '2001-00-22' and '2010-00-23') M ,
(Select u_Name as u_Name From Units where s_ID  IN (Select Unit_ID From MasterOrder where BillDate between '2001-00-22' and '2010-00-23'))N

[gll062]

Select u_Name,s_ID,BillSN,BillDate From MasterOrder inner join Units on MasterOrder.Unit_ID = Units.Unit_ID and MasterOrder.BillDate bwtween '2001-00-22' and '2010-00-23' and MasterOrder.s_ID = Units.s_ID

[jackeyaw]

谢谢大家 问题解决了