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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.