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