[thesite] sql question..

Dean Mah dsmah at home.com
Mon Jun 11 16:15:45 CDT 2001


rudy writes:
> 
> >     employees.emp_id = calendar.cal_emp_key ON
> >     employee_position_list.emp_pos_id = employees.emp_position_key;
> >
> >oracle is puking and just wonderingif my syntax is correct..
>
> rudy
> 
> p.s.  dean, how does AND/OR work?!   ;o)

It doesn't.  I learned SQL on Ingres and Oracle and they didn't use
the above join syntax so I really don't know what it is trying to do.
I wasn't sure if the snippet would be translated to AND or OR in the
where clause.

Dean




More information about the thesite mailing list