"Not" operator not functioning in t-sql

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 373,461 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,967 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser:

Thread Tools Display Modes

Views: 5382 | Replies: 0

•

Join Date: Mar 2004

Location: Brisbane

Posts: 632

Reputation: Slade has a spectacular aura about

Rep Power: 7

Solved Threads: 6

Slade

Offline

Practically a Master Poster

"Not" operator NOT functioning in t-sql

Sep 8th, 2004

Ok guys, check this out

Help with Code Tags

(Toggle Plain Text)

select app_given, app_surname, contract.contractID
from contract, progression
where pay_nop like 'PAY'
and
contract.status like 'Active'
and
app_type like 'Apprenticeship'
and
Contract.ContractID = progression.contractid
group by contract.contractid, app_given, app_surname

Ok, this works FINE. But, when I try to add Not..:

Help with Code Tags

(Toggle Plain Text)

Not Contract.ContractID = progression.contractid

It just brings up all of the contract ID's, including the one's in the progression table. What I want it to do is bring up the contract Ids that ARENT in the progression table.

Thanks in advance for your help,

Slade

Formerly known as Slade.