Dlookup in Access 2007

[Vicky]

Dear Sirs, I have two tables which contains number of files which goes from two levels before reaching client. In table 1 I have level 1st data & in table 2 I have level 2nd data. What I need now is Level 2nd data to be automatically added in table 1 which is different for each file. For example: In table 1 I have File number, User name, User ID & in table 2 I have file no, Editor name, Editor ID. I need to fetch results for every file in one table to have all fields correct i.e. File no (Same in both tables), User name, User ID, Editor name, Editor ID. Can you please help me out?

Thanks,
Vicky

[ArviLaanemets]

SELECT a.FileNo, b.UserName, b.UserId, a.EditorName, a.EditorID FROM Table2 a LEFT OUTER JOIN Table1 b ON b.FileNo = a.FileNo