Jeez, who was your SQL instructor????

:)



>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