Multiple tables with same field

[mparab]

Hello,

I'm trying to do a query on two table. One table holds time worked, the other time off. Both have the same field 'date' with different values. When I run the query, one of the date fields just repeats the values over and over
i.e:'2002-10-15'
'2002-10-15'
'2002-10-15', and so on

Then I want to display the dates in order on a web page so people can review there timesheets.

Just wondering if anyone has any ideas.

Thanks in advance,

M

[OhLordy]

Could you post your query and db structure please?

[btlewis420]

SELECT table1.date AS t1date, table2.date AS t2date FROM table1, table2 WHERE 1;

You really shouldn't name a field "date" though since DATE is a data type. How about my_date or foo_date or something unique?