Working with 2 dates

[willpower]

Two tables...debits and credits

 

date field in each with dateTime format.

 

I need to select all rows where user='$userID' and then print them to screen in a chronological order.

 

I have no idea how to do this over 2 tables.  Any help appreciated.

 

Thanks

 

Will

 

[MadTechie]

can you not do this

 

SELECT credits.*, debits.*
FROM credits, debits
ORDER BY debits.date, credits.date ASC