SQL db query to exclude some entries

		Microsoft Office Forums > Microsoft Excel > Excel
SQL db query to exclude some entries

FAQ

Thread Tools

Display Modes

11-09-2012, 03:50 AM

jillapass

Windows 7 32bit SQL db query to exclude some entries

Office 2007

Novice

Join Date: Dec 2011

Posts: 26

SQL db query to exclude some entries

I have 2 tables, one for clients, and one for client bookings
I want to find all clients that have never made a booking.

How do I do a query that links these 2 tables, but only selects those where there is not an entry in the 2nd table.

Thanks

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel?	mag	Excel	0	10-18-2012 11:15 AM
Exclude phrase from email	kiwiora	Outlook	2	07-16-2012 03:03 PM
VBScript.RegExp: exclude a particular word	tinfanide	Excel Programming	2	06-07-2012 06:52 AM
Edit spell check dic to exclude words?	franklekens	Word	1	07-03-2010 09:57 AM
Text Box Query	Meljord	Word	3	12-15-2009 12:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 PM.