一条简单语句100分相送

[twtetg]

SELECT ManufacturerId, ManufacturerName FROM AppraisalManufacturer 
WHERE ManufacturerId IN (SELECT DISTINCT ManufacturerId FROM  Appraisal
WHERE AppraisalId IN(SELECT AppraisalId FROM AppraisalInformation where SalerId = 1))

绑定下拉框的数据，谢谢！

[twtetg]

结帖了，谢谢各位！

[shilei831115]

不知道LZ想要干嘛

[pt1314917]

什么问题？

[zzxap]

[code=SQL]
SELECT ManufacturerId, ManufacturerName FROM AppraisalManufacturer a
inner join (SELECT DISTINCT ManufacturerId FROM Appraisal)b on a.ManufacturerId=b.ManufacturerId
inner join AppraisalInformation c on a.AppraisalId=c.AppraisalId and c.SalerId = '1'

[/CODE]

[delphi_new]

都什么年代了还用IN

[twtetg]

晕，我在LINQ区发的帖子啊，意思是用LINQ怎么写上面的语句。。。失误了

[twtetg]

只是想得到LINQ的表现形式而已。。。

[zzxap]

linq的没有研究过，可以百度一下用法

[pt1314917]

var ids=from b in Appraisal  
		join c in AppraisalInformation on b.AppraisalId equals c.AppraisalId
        where c.salerid==1
		select  new
		{
			b.ManufacturerId
		};

var sss = from a in AppraisalManufacturer
		  join b in ids.Distinct() on a.ManufacturerId equals b.Value
			select new
			{
				a.ManufacturerId, a.ManufacturerName
			};

[wuyq11]

http://www.cnblogs.com/22331218/archive/2008/05/28/1209062.html