webguync Posted April 15, 2009 Share Posted April 15, 2009 Hi, I need a SQL statement that will pull out all of the data from the fields in Table A and also combine info from just one field in table B. I am having difficulty coming up with the right SQL statement. I tried UNION, but since all there are an uneven number of columns in each table that didn't work. Also tried LEFT JOIN, but that doesn't work because the two tables don't share any common columns. Any ideas on the best method? Link to comment https://forums.phpfreaks.com/topic/154222-help-with-sql-statement-pulling-data-from-two-tables/ Share on other sites More sharing options...
Mchl Posted April 15, 2009 Share Posted April 15, 2009 If these tables do not share any columns, how MySQL is supposed to return any meaningful data? Care to give an example of data in tables, and what you would like to get? Link to comment https://forums.phpfreaks.com/topic/154222-help-with-sql-statement-pulling-data-from-two-tables/#findComment-810826 Share on other sites More sharing options...
webguync Posted April 15, 2009 Author Share Posted April 15, 2009 my bad, they did have a common column (duh). I think I have what I needed with the LEFT JOIN. Link to comment https://forums.phpfreaks.com/topic/154222-help-with-sql-statement-pulling-data-from-two-tables/#findComment-810841 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.