[thesite] sql question..

Daniel J. Cody djc at starkmedia.com
Mon Jun 11 13:58:07 CDT 2001


i'm tyring to create a view.. does this syntax look correct?

SELECT calendar.cal_date, calendar.cal_event,
     employees.emp_id, employees.emp_first,
     employees.emp_last,
     employee_position_list.emp_pos_name,
     calendar.cal_id
FROM employee_position_list INNER JOIN
     employees INNER JOIN
     calendar ON
     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..

thankie :)





More information about the thesite mailing list