Help with a sproc

[kenhutchings]

Hi all,

Basically What i have is 2 tables

tbl1 - Clients
tbl2 - orders

Now what I want is all the clients who havent placed an order. Can anyone show me the basics

Cheers

Ken

 

[jbenson001]

Select (columns you want from the tables)
From
Clients c
Inner Join Orders o ON c.(some ID column) = o.(some id column)

 

[Juice05]

Actually, he is looking for clients who <b>haven't</b> placed an order.

Select * From Clients
Where [ClientID-Not sure what your identifier is] Not in (Select [ClientID-Not sure what your identifier is] From Orders)

 

[vongrunt]

Same thing translated to join:

select Clients.*
from Clients
left outer join Orders on Clients.clientID=Orders.clientID
where Orders.clientID is null

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[jbenson001]

Ooops my bad. I quickly read that post. Good catch.