[osama_]

In Microsoft Access, I have two tables:
Example:
Devices:
Dev_id Dev_name
1 Dev1
2 Dev2
3 Dev3
and
Faults:
Fault_id Dev_id Date
1 1 3/5/2011
2 1 4/5/2011

I need a query that displays ALL devices and ,if exists, the corresponding faults, like that:
Dev_id Dev_name Date
1 Dev1 3/5/2011
1 Dev1 4/5/2011
2 Dev2 (Null or anything)
3 Dev3 (Null or anything)

can this be done ?

[Jstall]

Hi,

You could do this using a left join. Something like:

SELECT d.*,f.date
FROM Devices d
LEFT JOIN Faults f ON f.Dev_id = d.Dev_id

Would do the trick.

Hope this helps

[osama_]

Thanks a lot, it worked greatly