Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Making SQL Query problem

Oct 21, 2003, 3:45 PM
marco-marco
New User (2 posts)
Oct 21, 2003, 3:45 PM
Views: 4613
Shortcut
Quote Reply
Making SQL Query problem
ok, heres the problem I have.

I have 2 table, one called 'Property' and the other 'Booking'.

Property has the column 'PropertyID' containing the values '1','2','3','4' and '5'

Booking has a FK 'PropertyID' containing the values '1','1','2' and '2'

I want to make a query to return the values '3','4' and '5'. Returning '1' and '2' is simple, but cant find how to return the inverse of this. Can anyone help?????
Subject Author Views Date
Thread Making SQL Query problem marco-marco 4613 Oct 21, 2003, 3:45 PM
Post Re: [marco-marco] Making SQL Query problem 		Andy 4413 Oct 22, 2003, 4:06 AM