<p>今天碰到一个问题,研究了一下终于解决了。</p><p>把它做成题目给大家练练吧。SQL查询的。</p><p>回复可见贴。一共有两题,第一题2BB,第二题3BB,全部答对5BB。贴出SQL语句就可以了。</p><p>重复答题不计分。</p><p>BB发完为止。</p><p><br/></p><p>好久没人答题,现公布答案:</p><p>1、select a.产品型号,a.产品规格,b.单价 from [产品类别$] as a left join [单价表1$] as b on a.产品型号=b.产品型号 and a.产品规格=b.产品规格 where a.产品类别="一类产品"</p><p>2、select a.产品型号,a.产品规格,b.单价 from [产品类别$] as a left join (select * from [单价表1$] union all select * from [单价表2$]) as b on a.产品型号=b.产品型号 and a.产品规格=b.产品规格</p>
[此贴子已经被作者于2009-12-22 9:29:54编辑过] |