Crimpage Posted May 19, 2006 Share Posted May 19, 2006 Hi All,Anyways... I have to try and fix a MS Access report my boss actually PAID someone to do, and it runs like crap.We have an Active table, and an Archive table, to make access to the data in the active table quicker.When running reports tho, we need to add the results of the Active table to the results from the Archive table.They have one query running on the active, and the same one running on the Archive table. It then uses a MS Access thing called a UNION SELECT, which pretty much just puts the results on top of each other to make 1 recordset.Is there a type of join that can do this? UPPER JOIN sounds like a good name for one... thats what I would call it if I made it...By the way, I'm not using PHP for (Although I would like to...)Cheers,David. Link to comment https://forums.phpfreaks.com/topic/9991-sql-joins/ Share on other sites More sharing options...
Barand Posted May 19, 2006 Share Posted May 19, 2006 In a word, No.JOINS take data from related records and aggregate the related columns of data in to single row.In this case, UNION is the way to do it. Link to comment https://forums.phpfreaks.com/topic/9991-sql-joins/#findComment-37129 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.