Hi All,

I have 5 tables all with the same fields, one of which is the date. I want to write a query that will return a single row for each date that contains the values of all the other fields in each table. I have tried using the distinct key word in my select statement, but it only seem to work on a single column.

What I get is multiple rows for each date, with some columns having a null value.

Does anyone have any ides how to accomplish the seeming simple task?

Thanks,

Jim