NOT IN sytnax

pokermagic · #1 (**permalink**) 07-14-04, 19:16

I have a SQL that I can't get to work and I think I have the syntax incorrect. Here it is.

SELECT DISTINCT manufacturers.mfrid, manufacturers.mfrname FROM manufacturers, models, oemmemory, crossref, pdppart, exclude WHERE manufacturers.mfrid = models.mfrid AND models.modelid = oemmemory.modelid AND crossref.crossrefid = oemmemory.crossrefid AND crossref.crossrefid = pdppart.crossrefid AND models.modelid not in(select exclude.modelid from exclude) AND models.catid = ? ORDER BY manufacturers.mfrname;

Basically it tells me I have an error near the select exclude.modelid from exclude.

What I'm trying to do is to get a list of models but not ones that are listed in the exclude table.

Thanks for any help.

r937 · #2 (**permalink**) 07-14-04, 21:34

subqueries not supported before version 4.1

try this --

Code:

select distinct 
       manufacturers.mfrid
     , manufacturers.mfrname 
  from manufacturers
inner
  join models
    on manufacturers.mfrid 
     = models.mfrid 
inner
  join oemmemory
    on models.modelid 
     = oemmemory.modelid 
inner
  join crossref
    on oemmemory.crossrefid  
     = crossref.crossrefid 
inner
  join pdppart
    on crossref.crossrefid 
     = pdppart.crossrefid
left outer
  join exclude 
    on models.modelid
     = exclude.modelid
 where models.catid = 937 
   and exclude.modelid is null
order 
    by manufacturers.mfrname

Internet Services

Web Development

Digital Marketing

Consumer Tech