SQL语句中LEFT JOIN如何应用

2024-12-27 05:49:01
推荐回答(2个)
回答1:

select a.BillNO,a.BillDate,a.GusetNo,a.Amount,a.CheckPerson,b.GuestName,b.Tel
from G_Guest as a left join P_OutM as b
on a.GuestNo=b.GuestNo

回答2:

SELEC *FROM P_OutM LEFT JOIN G_Guest ON P_OutM.GuestNo=G_Guest .GuestNo