朋友，

请使用此功能。希望这对你有所帮助。



string query1 = SELECT count（distinct DESC7）FROM ix_spc_planogram（NOLOCK）WHERE dbstatus = 1;

string query2 = SELECT count（ distinctType）FROM Csg_Range_In_Store（NOLOCK）WHERE DisplayGroup IN（'+ query1 +'）;



如果帮助回复必须谢谢......

Hi Friend,
Please use this. hope this will help to you.

string query1 = SELECT count (distinct DESC7) FROM ix_spc_planogram (NOLOCK) WHERE dbstatus= 1";
string query2 = SELECT count (distinct EquipmentType) FROM Csg_Range_In_Store (NOLOCK) WHERE DisplayGroup IN ('"+ query1+ "')";

If help reply must Thanks...