willpower Posted November 20, 2007 Share Posted November 20, 2007 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 Link to comment https://forums.phpfreaks.com/topic/78091-working-with-2-dates/ Share on other sites More sharing options...
MadTechie Posted November 20, 2007 Share Posted November 20, 2007 can you not do this SELECT credits.*, debits.* FROM credits, debits ORDER BY debits.date, credits.date ASC Link to comment https://forums.phpfreaks.com/topic/78091-working-with-2-dates/#findComment-395213 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.