SELECT * FROM supermag.smcard
WHERE
idclass IN (SELECT id FROM supermag.sacardclass WHERE tree LIKE '[B]5.[/B]%' ) AND
article NOT IN (SELECT article FROM supermag.smcardproducers)
SELECT *
FROM supermag.smcard
inner join supermag.sacardclass on (smcard.idclass = sacardclass.id)
left outer join supermag.smcardproducers on (smcardproducers.article = smcard.article)
WHERE
sacardclass.tree LIKE '5.%' and smcardproducers.article is null
select SMCard.article,
SMCard.name,
SACardClass.name,
smcardproducers.PRODUCERID
from SACardClass, SMCard, smcardproducers
where SACardClass.tree like '1.%'
and SACardClass.id = SMCard.IDClass
and smcardproducers.ARTICLE=SMCard.article
and smcardproducers.PRODUCERID is null
select SMCard.article,
SMCard.name,
SACardClass.name,
smcardproducers.PRODUCERID
from SACardClass, SMCard, smcardproducers
where SACardClass.tree like '1.%'
and SACardClass.id = SMCard.IDClass
and smcardproducers.ARTICLE=SMCard.article
and smcardproducers.PRODUCERID is null
select SMCard.article, SMCard.name, SACardClass.name, SACardClass.tree, rep_getcardclasspath(SACardClass.tree) grp, -- это не обязательно, просто для удобства smcardproducers.PRODUCERID from SACardClass, SMCard, smcardproducers where SACardClass.tree like '1.%' and SACardClass.id = SMCard.IDClass and SMCard.article=smcardproducers.ARTICLE(+) -- вот тут плюсик обязательно and smcardproducers.PRODUCERID is null