[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