sql语句怎么写

[zs174]

有两个表
table
id date no order
1 2016-8-25 1234 9999999
2 2016-8-25 2345 4548797
3 2016-8-26 1234 999999
table b
date no seat
2016-8-25 1234 41
2016-8-25 6344 41


结果想要
id date no order seat
1 2016-8-25 1234 99999999 41
2 2016-8-25 2345 4548797 null

怎么写这个好

[shoppo0505]

select table_A.id, table_A.date, table_A.no, table_A.order, table_B.seat from table_A left outer join table_B on table_A.no = table_B.no where table_A.date = ' 2016-8-25'

[中国风]

可用ID或Date取最小

SELECT  a.* ,
        b.Seat
FROM    TableA AS a
        LEFT JOIN TableB AS b ON a.[no] = b.[no]
WHERE   NOT EXISTS ( SELECT 1
                     FROM   TableA
                     WHERE  [no] = a.[no]
                            AND ID < a.ID )

SELECT  a.* ,
        b.Seat
FROM    TableA AS a
        LEFT JOIN TableB AS b ON a.[no] = b.[no]
WHERE   NOT EXISTS ( SELECT 1
                     FROM   TableA
                     WHERE  [no] = a.[no]
                            AND Date < a.Date )

[Ginnnnnnnn]

select table_A.id,  table_A.date, table_A.no,  table_A.order, b.seat
from table_A
left join  table_B b on  table_A.no =  b.NO AND table_A.date = b.date
WHERE EXISTS(SELECT * FROM table_B WHERE table_A.date = date)

[chinawood1980]

update a set a.seat =b.seat from tablea a,tableb b where a.date =b.date

[zs174]

用KanzakiOrange 的方法了，感谢大家