描述如下:
sql 1:
select substr(b.operdatedate,1,10) 'time'
from card_sale_note d, card_sale_card b, card_type c
where (d.id = b.id and d.if_new_card = b.if_new_card
and b.if_exit_card is null and b.type_id = c.type_id)
and date(b.operdatedate)>=date('2006-07-27 00:00:00')
and date(b.operdatedate)<=date('2007-07-27 23:59:59')
group by substr(b.operdatedate,1,10) order by substr(b.operdatedate,1,10) asc
返回为
time
2007-07-12
2007-07-25
2007-07-26sql 2:
select * from good_day_money where moneyOne > '0.000'
返回为
day moneyOne moneyTwo
2006-8-1 11111 11111
2006-8-2 22222 22222
2007-7-12 33333 33333
2007-7-25 44444 44444
2007-7-26 55555 55555
问题:
我如何才能在sql 1中把sql 2中查到的记录,但sql 1没有包含近来的,包含近来啊?
sql 1:
select substr(b.operdatedate,1,10) 'time'
from card_sale_note d, card_sale_card b, card_type c
where (d.id = b.id and d.if_new_card = b.if_new_card
and b.if_exit_card is null and b.type_id = c.type_id)
and date(b.operdatedate)>=date('2006-07-27 00:00:00')
and date(b.operdatedate)<=date('2007-07-27 23:59:59')
group by substr(b.operdatedate,1,10) order by substr(b.operdatedate,1,10) asc
返回为
time
2007-07-12
2007-07-25
2007-07-26sql 2:
select * from good_day_money where moneyOne > '0.000'
返回为
day moneyOne moneyTwo
2006-8-1 11111 11111
2006-8-2 22222 22222
2007-7-12 33333 33333
2007-7-25 44444 44444
2007-7-26 55555 55555
问题:
我如何才能在sql 1中把sql 2中查到的记录,但sql 1没有包含近来的,包含近来啊?
from good_day_money a
left outer join
(
select substr(b.operdatedate,1,10) 'time'
from card_sale_note d, card_sale_card b, card_type c
where (d.id = b.id and d.if_new_card = b.if_new_card
and b.if_exit_card is null and b.type_id = c.type_id)
and date(b.operdatedate)>=date('2006-07-27 00:00:00')
and date(b.operdatedate)<=date('2007-07-27 23:59:59')
group by substr(b.operdatedate,1,10)
) b
on a.day = b.time