jakebur01 Posted March 15, 2011 Share Posted March 15, 2011 I have two tables with the same columns. ARINVOI and ARYINVO. ARINVOI stops at 2011-02-26 and ARYINVO starts at 2011-02-27. The ARYINVO is basically a history table. The ARINVOI only keeps data for so long before transferring it into ARYINVO. I am wanting to attach the tables together as if they were one and query sales data. Here is a query for one of the tables: SELECT ITOTAL FROM ARYINVO WHERE `INVDTE` >= '$YTDB' and `INVDTE` <= '$YTDE' AND `CUSTNO` <> '01885' AND `REFNO` <> 'CR. MEMO' Quote Link to comment https://forums.phpfreaks.com/topic/230742-table-join-or-attach/ Share on other sites More sharing options...
fenway Posted March 17, 2011 Share Posted March 17, 2011 Huh? Quote Link to comment https://forums.phpfreaks.com/topic/230742-table-join-or-attach/#findComment-1188737 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.