Error: Only one expression can be specified......

[luvmy2kids]

I have the below query:

Select x.intid, x.fieldid, x.extid, custid, name
from ss_hcsscsa.dbo.custcustomer mstr
LEFT OUTER JOIN integrateprod.dbo.intxref x on mstr.custid = x.extid and x.subscriberid = 2 and x.fieldid = 95
where name in (select * from ss_hcsscsa.dbo.top50clients)
group by custid, name, x.intid, x.fieldid, x.extid

I added this part: where name in (select * from ss_hcsscsa.dbo.top50clients)
because the same custid may be used in different databases, so what I want to get is only pulled those customers who are in my "top50clients" table.

Adding that line gives this error:
insert into #custtdata (intid, fieldid, extid, custid, name)

Please advise!

Thanks a bunch....

 

[kjv1611]

where name in (select * from ss_hcsscsa.dbo.top50clients)

Should be:

where name in (select [highlight]name[/highlight] from ss_hcsscsa.dbo.top50clients)

I think.

--

"If to err is human, then I must be some kind of human!" -Me

 

[luvmy2kids]

UGH!! Thanks!!!

 

[kjv1611]

Any time.

--

"If to err is human, then I must be some kind of human!" -Me