表:
A (uid[int],name[char],date[DATE])
B (uid[int],name[char],date[DATE])
C (uid[int],name[char],date[DATE]) SQL SEVER 2000 环境下正常运行SQL:
SELECT atemp.uid,btemp.name
FROM
A atemp ,
B btemp
WHERE
atemp .uid *= btemp.uid
AND btemp.date =*(select max(B.date) from B where B.uid =* atemp.uid )由于在现在的环境中'=*'和'*='得不到技持.如何转换成用LEFT OUTER JOIN 和 RIGHT OUTER JOIN 写成的等价SQL语句?
人多力量大,大家帮帮忙.
A (uid[int],name[char],date[DATE])
B (uid[int],name[char],date[DATE])
C (uid[int],name[char],date[DATE]) SQL SEVER 2000 环境下正常运行SQL:
SELECT atemp.uid,btemp.name
FROM
A atemp ,
B btemp
WHERE
atemp .uid *= btemp.uid
AND btemp.date =*(select max(B.date) from B where B.uid =* atemp.uid )由于在现在的环境中'=*'和'*='得不到技持.如何转换成用LEFT OUTER JOIN 和 RIGHT OUTER JOIN 写成的等价SQL语句?
人多力量大,大家帮帮忙.
SELECT atemp.uid,btemp.name
FROM A atemp
LEFT JOIN B btemp ON atemp.uid = btemp.uid
WHERE
btemp.date = (select max(B.date) from B where B.uid = atemp.uid )记得结贴哦
FROM
A atemp left outer join
B btemp
on
atemp.uid = btemp.uid
where
btemp.date =(select max(B.date) from B where B.uid =atemp.uid )