Re: RE nedd help with sql

[Zoran Avtarovski <zo...@sparecreative.com>]

This is what I tried first but it threw an SQL error.

Z.


> I think you can use a sub query so
> 
> SELECT * FROM Users as U
> left outer join ( Select FROM UserCat WHERE status = 1 ) UC on U.user_id =
> UC.user_id  
> WHERE U.status = 1
> 
> Steve
> 
> 
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, confidential
> information and/or be subject to legal privilege. It should not be copied,
> disclosed to, retained or used by, any other party. If you are not an intended
> recipient then please promptly delete this e-mail and any attachment and all
> copies and inform the sender. Thank you.