[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