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' 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? Link to comment https://forums.phpfreaks.com/topic/230742-table-join-or-attach/#findComment-1188737 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.