SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL statement that omits records

468183Feb 16 2006 — edited Mar 9 2006

Hi, I have created a Record Group in forms but I am having some problems with the SQL to populate it.

I have a column Surname in a table 'Staff'. My record group reads in the names from this column. I also have a table 'Holiday' which has a foreign key of staff_id.

What I want is to write an SQL query for the record group that will list the staff surnames from table 'Staff' but leave out those surnames that have their staff_id in table 'Holiday'.

I can't get my head around how to do it. Any help would be greatly appreciated.

Kevin

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2006

Added on Feb 16 2006

6 comments

269 views