[thesite] sql question..
Dean Mah
dsmah at home.com
Mon Jun 11 14:13:42 CDT 2001
CREATE VIEW view_name AS
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, employees, calendar
WHERE employees.emp_id = calendar.cal_emp_key AND/OR
employee_position_list.emp_pos_id = employees.emp_position_key;
Daniel J. Cody writes:
> 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..
More information about the thesite
mailing list