Query Help

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

Simplest way is to do this:

Code:

---

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.

thnkx dat did it