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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/78091-working-with-2-dates/#findComment-395213 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.