有三张表,A表,BILLID,BILLNAME BILLDATE
B表,BILLID, PRICE
C表,BILLID,BILLType
我现在想从这三个表查询时间BILLDATE从2006年9月1号 到2006年月日9月30号的BILLID相等的
A.BILLID,B.PRICE,C.BILLTYPE
B表,BILLID, PRICE
C表,BILLID,BILLType
我现在想从这三个表查询时间BILLDATE从2006年9月1号 到2006年月日9月30号的BILLID相等的
A.BILLID,B.PRICE,C.BILLTYPE
where A.BILLID=B.BILLID and B.BILLID=C.BILLID and A.BILLID=C.BILLID
and A.BILLDATE between '2006-09-01' and '2006-09-30'
from A
inner join B on A.BILLID=B.BILLID
inner join C on A.BILLID=C.BILLID
where A.BILLDATE between '2006-09-01' and '2006-09-30'
from a,b,c
where a.BILLID= b.BILLID and a.BILLID = c.BILLID and a.BILLDATE >= '2006-09-01' and a.BILLDATE <= '2006-09-30' select A.BILLID,B.PRICE,C.BILLTYPE
from a,b,c
where a.BILLID= b.BILLID and a.BILLID = c.BILLID and (a.BILLDATE between '2006-09-01' and '2006-09-30')