Two tables in query

[Pro]

Hello All...
Please Help .

I have two tables (1- User) , (2-Dept) have filed name D_Sum and link ID of [User] to UserID of [Dept] table

My question is how to add both of tables and get all user with filed name D_Sum form [Dept] table
in order to filter User with that have dept or not

Note: I try to do it but I get only user with dept :banghead: ,, I need all user

thanks ,,,,,,

 

[pbaldy]

Edit the join between the tables by double or right clicking on the join line.

 

[Pro]

I do it after that ?

Edit the join between the tables by double or right clicking on the join line.

 

[pbaldy]

Huh? When you get to that point, the correct choice should be obvious.

 

[Pro]

I try and see

 

[Pro]

hhh ,,, thanks my Dear

it...ok

 

[pbaldy]

No problem.