johnsmith153 Posted July 28, 2010 Share Posted July 28, 2010 Tables / fields: oldCustomerData fields: Name, Address newCustomerData fields: fullName, personAddress Something like this is what I am trying to achieve: "SELECT a.Name, a.Address FROM oldCustomerData AS a + b.fullName, b.personAddress FROM newCustomerData AS b" ..so that it is all returned in same return array. Link to comment https://forums.phpfreaks.com/topic/209143-selct-data-from-2-mysql-tables-together/ Share on other sites More sharing options...
johnsmith153 Posted July 28, 2010 Author Share Posted July 28, 2010 SELECT fieldname FROM table UNION ALL SELECT fieldname FROM table2 Link to comment https://forums.phpfreaks.com/topic/209143-selct-data-from-2-mysql-tables-together/#findComment-1092273 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.