On Fri, Jun 27, 2003 at 23:16:18 -0700,
Ludwig Lim <[EMAIL PROTECTED]> wrote:
>
>Is there way of rewritting :
>SELECT a.status,
>employee_id
>FROM permission a LEFT JOIN
> ( SELECT * FROM employee WHERE employee_id
> =5) as b ON (a.status = b.status)
>WH
Ludwig Lim <[EMAIL PROTECTED]> writes:
>Is there way of rewritting :
>SELECT a.status,
>employee_id
>FROM permission a LEFT JOIN
> ( SELECT * FROM employee WHERE employee_id
> =5) as b ON (a.status = b.status)
>WHERE status='test'
> into a query that has
