[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