select t1.Fname,t1.fnumber,t3.fname,t3.fnumber from t1 join t2 on t1.fitemid = t2.fitemid, t2 join t3 on t2.funitid = t3.fmeasureunitid where fcode = '你自己的code'
select t1.FName,t1.FNumber,t3.FName,t3.FNumber ftom t_ICItemCore t1 join t_ICItemBase t2 t1.FItemID=t2.FItemID join t_MeasureUnit t3 on t2.FUnitID=t3.FMeasureUnitID
第2个回答 2010-09-09
用left join 具体怎么用这里说不清楚,你去百度查下相关资料把
第3个回答 2010-09-09
SELECT t1.FName, t1.FNumber, t3.FName, t3.FNumber FROM t_ICItemCore t1, t_MeasureUnit t3 WHERE t1.FCode = xxxx AND t3.FMeasureUnitID = (SELECT FUnitID FROM t_ICItemBase WHERE FItemID = t1.FItemID)