Hi:
1) Is the ON clause of an OUTER JOIN always
evaluated first before the WHERE clause?
2) Given the ff SQL statement :
SELECT employee_id, a.status as status FROM permissions a LEFT JOIN (select * from employee where
employee_id= 3)
as b on (a.status=b.status) WHERE a.status='test';
Is there a way to rewrite the query as a view such
that one can do:
select * from test_view where employee_id=3 and status='test';
Thank you very much,
ludwig lim
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com