[Resolved] help to dummy

[BITRU]

i know this is stupped but i am not good with my sql at all.

i have
mag - mid, mnum.....
and
cover - mnum.....

mag.mnum got all the numbers
cover.mnum only some of them (whiche are processed)

how do i get mag.mid which got mag.mnum which does not have match in cover.mnum

[Dr_John]

SELECT mid
FROM mag
WHERE mnum NOT in (SELECT mnum FROM cover);

[BITRU]

Damee thanks. I knew that i can use query in query but i did not know how. Thanks for showing me.