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!

Relational Division

547160Nov 20 2006 — edited Nov 20 2006

I need to create sql code that will do the following, I have been working on this for ages but still can't get it to work :(

Identify all clients who have viewed all properties with three rooms. (I have entered the tables used below)

client
client_no
f_name
l_name

property_for_rent
property_no
rooms

viewing
client_no
property_no

Any help given, is greatly appreciated. As this is driving me mad!!!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2006

Added on Nov 20 2006

9 comments

306 views