阅读背景:

加入和NULL数据的SQL Server问题

来源:互联网 

I need to get all entries from the table 'issued' and display receipt information for that ISBN if it appears that day on the receipts daily table load. So I could have say 10 rows from issued, but 2 of them have receipt info that day so that data gets loaded in the proper columns from the receipts table. Otherwise just have them as NULLS. The joining keys would be ID and ISBN. I need to get all entries from the table 'issue




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: