Code: Select all
select ma.mail_no, me.mail_no, me.pers_no, me.lastname, me.firstname
from me
left outer join ma on me.mail_no = ma.mail_no
where ma.mail_no is null
order by me.lastname, me.firstname
viewtopic.php?f=1&t=13911
Moderators: Moderators, Tech Support
Code: Select all
select ma.mail_no, me.mail_no, me.pers_no, me.lastname, me.firstname
from me
left outer join ma on me.mail_no = ma.mail_no
where ma.mail_no is null
order by me.lastname, me.firstname