这条sql语句应该如何写?????

Question

主表一：Master
MasterId  DateTimeIn   InType
001       03-02-02     采购入库
002       03-02-03     采购入库明细表：Detail
MasterId ProductId Incount StockId
001      P001       30     ST001 
001      P002       34     ST001
002      P003       10     ST003
002      P005       32     ST003如何在已经StockId的情况下，得出如下结果，这条sql语句应该如何写
InType        MasterId    DateTimeIn  ProductId  Incount
采购入库      001         03-02-02    P001        30
采购入库      001         03-02-02    P002        34
采购入库      002         03-02-03    P003        10 
采购入库      002         03-02-03    P005        32

Answer 1

select a.InType,b.MasterId,a.DateTimeIn,b.ProductId,b.Incount
from Master a,Detail b where a.MasterId =b.MasterId

Answer 2

不好意思，写错了，我是说已 StockId 为输入条件？？？？？

Answer 3

已 StockId 为输入条件？？？？？什么意思???select a.InType,b.MasterId,a.DateTimeIn,b.ProductId,b.Incount
from Master a,Detail b where a.MasterId =b.MasterId and a.MasterId ='你的条件'这样???

Answer 4

InType,b.MasterId,a.DateTimeIn,b.ProductId,b.Incount
from Master a,Detail b where a.MasterId =b.MasterId and StockId='你的条件'