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.