Help! mySQL query

SELECT col1, col2, (coloumn_ x FROM another_table ), col4 FROM table1; is that possible? in my case i want to display an item's supplier name using supplier_id in the mentioned parenthesis. have been using inner join but no luck for within parenthesis.

20th Nov 2017, 9:20 AM
Jastria Rahmat
Jastria Rahmat - avatar
2 Answers
+ 2
You'd need to do a join on supplier_id and supplier_id would need to be in both tables.
20th Nov 2017, 10:24 AM
Michael Foster
Michael Foster - avatar
+ 2
select tbl1.col1, tbl2.col1, tbl1.col2, tbl2.col2 from tbl1, tbl2;
10th Jun 2020, 3:38 AM
ricdossc - avatar