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
Post #1 of 2
Views: 4508
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?????
Oct 22, 2003, 4:06 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Oct 22, 2003, 4:06 AM
Post #2 of 2
Views: 4304
Shortcut
Quote Reply
Re: [marco-marco] Making SQL Query problem In reply to
Maybe this?

SELECT UNIQUE(PropertyID) FROM Property,Booking

?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!