MySQL Select all columns from one table and some from another table

select mysql join
Alex picture Alex · Aug 16, 2010 · Viewed 247k times · Source

How do you select all the columns from one table and just some columns from another table using JOIN? In MySQL.

Answer

Tatu Ulmanen picture Tatu Ulmanen · Aug 16, 2010

Just use the table name:

SELECT myTable.*, otherTable.foo, otherTable.bar...

That would select all columns from myTable and columns foo and bar from otherTable.

Related questions

Combine Multiple child rows into one row MYSQL

Thanks in advance, I just can't seem to get it! I have two tables Ordered_Item ID | Item_Name 1 | Pizza 2 | Stromboli Ordered_Options Ordered_Item_ID | Option_Number | Value 1 43 Pepperoni 1 44 Extra Cheese 2 44 Extra Cheese What I am looking to output …

Read More
What is the default MySQL JOIN behaviour, INNER or OUTER?

So I've been looking through the internet the last hour, reading and looking for the definitive answer to this simple question. What is the default JOIN in MySQL? SELECT * FROM t1 JOIN t2 Is that the same as SELECT * FROM …

Read More
How do I get a count of associated rows in a left join in MySQL?

I have two tables, a vehicle table with columns: id stock year make model and an images table with columns: id vehicle_id name caption default tinyint(1) I am trying to list the vehicle's information, its default image, and a …

Read More