Quaries Multiple table + Null Problem

[syah96]

Hello
Here the thing, i got multiple table where it share one similar field which (1 to 1 relationship). All the table connect to staff profile table where sharing the staff ID. The table content different record. What i want to do is to make a query( or any other way) to display all records in all table through the staff ID. However the problem is some of the table may not contain some of staff record.
Can someone help me..

[orange]

I don't understand your post.
???

All the table connect to staff profile table where sharing the staff ID

.????
Please show your table design and a few records.

[syah96]

The relation like this. I cant upload the file since it too big. Well, the staff form relate to all table where in query i want all the table show their data based on staff ID. But, some table not necessarily to have data.

[alansidman]

Why do you have multiple tables with the same field names. This does not seem to be a normalized state for your db. If your tables are for departments, then I think you could combine them into one table with a field identifying the department. I don't believe your current design is the most efficient.

To answer your question, you would design your query in this manner

Select Staff.*,tblInv.*
From Staff LEFT join tblInv on Staff.[No Staff]= tblInv.[Nama];

I have only done this for joining two tables. The Left join will give you all data in the Staff table and only data from the tblInv where data exists. If you were to join all the tables, this would be your format. I would urge you however to change the design of your database and it will make queries easier to manipulate in the future.