Query Help

[hyousuf2]

well it may not be the rigth forum but pls help
i need to run a query in SQL server like this
select * from tblPayments where clientid = (select clientid from tblUsers where gfaxcrm = 'Yes')
it says that a subquery can return more than one result.what should i do

[Blade]

Simplest way is to do this:

select * from tblPayments where clientid IN (select clientid from tblUsers where gfaxcrm = 'Yes')

Might not be the most efficient, depends on your db design, but it will work.

[hyousuf2]

thnkx dat did it