SELECT * FROM Product WHERE SmallProductClassNo=(SELECT SmallProductClassNo FROM BigProductClass WHERE BigDishClassNO=str)
产品大类 有 01,02;01大类有小类01,02,03;02大类有小类
04,05
查找大类为01的所有产品名称,SQL语句怎么写~~!
产品大类 有 01,02;01大类有小类01,02,03;02大类有小类
04,05
查找大类为01的所有产品名称,SQL语句怎么写~~!
2、SELECT * FROM Product WHERE SmallProductClassNo in (SELECT SmallProductClassNo FROM BigProductClass WHERE BigDishClassNO='01')
ADOQueryStage->Parameters->ParamByName("ITemp")->Value=CmbBigDishClass->Text.SubString(0,2);
FROM Product a
WHERE EXISTS ( SELECT 1
FROM BigProductClass b
WHERE BigDishClassNO = '01'
AND a.SmallProductClassNo = b.SmallProductClassNo )