請教：這條SQL多表聯接語句怎麼寫？(50分)

杜

杜風

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-01

• #1

有三個sql表：
name_table 有ID、姓名、部門等
level有ID、level_sort,date等
level_sort有level_sort,工資等
我要從這三個表中得出 ID、姓名、部門、date、工資
要求 level.ID=name_table.ID、level.level_sort=level_sort.level_sort、level_sort表中的DATE為最新的

 

L

louhong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-01

• #2

没学过SQL语法吗？
select a.ID,a.姓名,a.部門,b.date,c.工資 from name_table a,level b,level_sort c
where a.ID=b.ID and b.level_sort=c.level_sort
试试对不对。

 

杜

杜風

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-01

• #3

要date是最新的

 

Q

QuickSilver

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-01

• #4

Select AA.id,AA.姓名,AA.部门,DD.rq,CC.工资
From name_table AA,
level BB,
level_sort CC,
(select id,max(date) as rq from level group by id) DD
Where AA.id=BB.id and
BB.level_sort=CC.level_sort and
BB.date=DD.rq

 

Y

Yang J.Q.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-01

• #5

SELECT a.ID, a.姓名, a.部門, b.date, c.工資
FROM name_table a, level b, level_sort c
WHERE a.ID = b.ID
AND b.level_sort = c.level_sort
AND b.date = (SELECT MAX(b.date)
FROM name_table a, level b, level_sort c
WHERE a.ID = b.ID
AND b.level_sort = c.level_sort)

 

杜

杜風

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-04

• #6

多人接受答案了。