Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gunja99
Starting Member
5 Posts |
 Posted - 2000-12-09 : 10:31:23
|
| Hi all, After getting such a quick response from u guys, I have decided to let you all help me with my next problem!! It's really simple I guess, but I am just so thick! I need have 2 tables T03Customer, and T10AllocatedDialler, and am trying to find customers who do not have a dialler allocated to them! T03Customer has a primary key idCustomer and T10AllocatedDialler has a foreign key idCustomer.I just need to find Customers that exist who do not have a dialler allocated to them! ie. a customer exists with id=10 and there are no entries in T10AllocatedDialler with the idCustomer set to 10! Just need to find all these customers in a stored proc.Prolly really simple so please help!Cheers,Martin |
|
|
|
|
|
JOINs and Simple stuff like that!