ใช้คำสั่ง inner join , Left Join ...... เลือกใช้อันไหนก่อได้
Date :
15 ก.ย. 2550 16:53:30
By :
สายเหนือ
No. 2
Guest
select * from receive,status where receive.STATUS_ID= status.STATUS_ID;
select * from receive LEFT JOIN status on receive.STATUS_ID= status.STATUS_ID;
select * from receive LEFT JOIN status USING(STATUS_ID);
select * from receive LEFT JOIN status on receive.STATUS_ID= status.STATUS_ID;