Question on OUTER JOINS.

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match