新手问题,请问这两条SQL语句怎么整合到一起?

Question

select shopprodItemName,shopprodItemID from [QBS_shopProdItem] where shopID=1022select shopName from [QBS_Shop] where shopID=1022

Answer 1

這樣？select shopprodItemName,shopprodItemID from [QBS_shopProdItem] where shopID=1022
Union All
select shopName, Null from [QBS_Shop] where shopID=1022

Answer 2

select a.shopprodItemName,a.shopprodItemID,b.shopName from [QBS_shopProdItem] a, [QBS_Shop] b where a.shopID=1022 and a.a.shopID=b.a.shopID

Answer 3

select shopprodItemName,shopprodItemID from [QBS_shopProdItem] where shopID=1022
union all
select shopName shopprodItemName , shopprodItemID = 0 from [QBS_Shop] where shopID=1022

Answer 4

select shopprodItemName,shopprodItemID from [QBS_shopProdItem] where shopID=1022
Union All
select shopName, Null from [QBS_Shop] where shopID=1022--或者是select A.shopprodItemName, A.shopprodItemID, B.shopName from [QBS_shopProdItem] A Inner Join [QBS_Shop] B
On A.shopID = B.shopID
where A.shopID=1022

Answer 5

偶也来试试。SELECT shpprodItemName, shopproItemID FROM [QBS_shopProItem] aINNER JOIN [QBS_Shop] b ON a.shopID = b.shopID

Answer 6

应该是这样的吧：
 Limpire(昨夜小楼) ( ) 信誉：100  2007-08-08 16:11:30  得分: 0  
select a.shopprodItemName,a.shopprodItemID,b.shopName from [QBS_shopProdItem] a, [QBS_Shop] b where a.shopID=1022 and a.a.shopID=b.a.shopID

Answer 7

select a.shopprodItemName,a.shopprodItemID,b. shopName 
from QBS_shopProdItem a
left join QBS_Shop b on a. shopID = b. shopID
where b. shopID=’1022’