求教这个SQL语句怎么写

[langhaixin]

有三张表
BOOK(BOOK_ID,BOOK_NAME,BUYER_ID)
BUYER(BUYER_ID,BUYER_NAME)
SEND(SEND_ID,BUER_ID,BUYER_ADDRESS)

现在要显示 BOOK_ID,BUY_NAME,BUYER_ADDRESS这几个字段怎么显示阿

[CrazyFor]

select * from book a,buyer b ,send c where a.buyer_id=b.buyer_id and a.buyer_id=c.buyer_id

[friendliu]

SEND(SEND_ID,BUER_ID,BUYER_ADDRESS)
这个表的的第二个字段应该是BUYER_ID吧
select a.book_id,b.buyer_name,c.buyer_address
from book a,buyer b,send c
where a.buyer_id=b.buyer_id and c.buyer_id=b.buyer_id

[zjcxc]

select a.book_id,b.buyer_name,c.buyer_address
from book a inner join buyer on a.buyer_id=b.buyer_id
inner join send c on b.buyer_id=c.buyer_id

[CrazyFor]

select a.book_id,b.buyer_name,c.buyer_address from book a left join buyer b on a.buyer_id=b.buyer_id left join send c on a.buyer_id=c.buyer_id

[maconelxp]

select a.book_id,b.buyer_name,c.buyer_address from book inner join buyer b on a.buyer_id=b.buyer_id inner join send c on c.buyer_id=b.buyer_id

[tms320c3xx]

select a.book_id,b.buyer_name,c.buyer_address
from book a,buyer b, send c
where (a.buyer_id = b.buyer_id) and ( b.buyer_id = c.buyer_id)

[CrazyFor]

select a.book_id,b.buyer_name,c.buyer_address from book a left join buyer b on a.buyer_id=b.buyer_id left join send c on a.buyer_id=c.buyer_id

[maconelxp]

select a.book_id,b.buyer_name,c.buyer_address from book a inner join buyer b on a.buyer_id=b.buyer_id inner join send c on c.buyer_id=b.buyer_id

[愉快的登山者]

select A.BOOK_ID,B.BUY_NAME,C.BUYER_ADDRESS from BOOK A
left join BUYER B on A.BUYER_ID = B.BUYER_ID
left join SEND C on A.BUER_ID = C.BUER_ID

[zjcxc]

你给的字段应该有些写错了,大致的实现方法应该如上

[DanielSunny]

主要还是看这几个表的关系来确定用inner join 还上Left join 的

[paliang]

学习ing

[LoveSQL]

select A.BOOK_ID,B.BUY_NAME,C.BUYER_ADDRESS from BOOK A
left join BUYER B on A.BUYER_ID = B.BUYER_ID
left join SEND C on A.BUYER_ID = C.BUYER_ID
这样写，试试！