admin panel - special case query?

[BEFOR]

I have an admin panel that inserts values into tables. No problem.

What I need is to come up with a query that joins all tables, to give a "status" showing whether necesary values were inserted/exist in each of the tables.

All tables have M_ID in them, to join to a main table of which this is the primary id.

Here's the problem. Whenever any of the tables don't contain a M_ID value then the query goes blank, nothing returned.

Also there are (2) types of users, so while both types of users' values exist in the majority of all tables, some tables naturally don't contain 'the other type' values.

I plan on a 'do while' and can call the pretty graphics, but how can I flag when only certain values among the tables are not present in this case?

[Drakla]

Search for 'ubiquitous left join' it might be what you need

[BEFOR]

APOLOGIES, A LEFT JOIN only does the trick if I'm returning a single result. I'm getting blanks when trying call multiple values in a "do while'
Here's my scenario:

For example I have:

Mem.M_ID //the primary id to match

Which is or isn't in

MrunR (runtime) as MrunR.Mm_ID

MrunD (another runtime) as MrunD.Mm_ID

And always in:

MconR as MconR.Mm_ID