Small Question

[eluser]robertGM[/eluser]
Thanks for the input ... i have one more question related to a query.
How can add one more where to the subselection .. I need something like :

From : $sql='SELECT * FROM clienti WHERE id IN (SELECT DISTINCT `firma` FROM `program_saptamanal` WHERE firma != \\'\')';
to
$sql='SELECT * FROM clienti WHERE id IN (SELECT DISTINCT `firma` FROM `program_saptamanal` WHERE firma != \\'\')'; and where('agent_id', $user->id);

agent_id - is from program_saptamanal table

I want the users to select only there records not all the records ..


Thanks for the support.