Help! mySQL query

Question

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.

Answer 1

You'd need to do a join on supplier_id and supplier_id would need to be in both tables.

Answer 2

select tbl1.col1, tbl2.col1, tbl1.col2, tbl2.col2 from tbl1, tbl2;