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

by

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.

More Related Contents:

  1. How can I select data from different tables?
  2. Combine Multiple child rows into one row MYSQL
  3. What is the default MySQL JOIN behaviour, INNER or OUTER?
  4. MySQL cartesian product between two SELECT statements
  5. left join query keep a column empty
  6. What is better subquery vs literal on IN clause in mysql
  7. INNER JOIN ON vs WHERE clause
  8. SQL query return data from multiple tables
  9. SQL update from one Table to another based on a ID match
  10. How to use mysql JOIN without ON condition?
  11. Notice: Array to string conversion in
  12. When to use STRAIGHT_JOIN with MySQL
  13. MySQL – Selecting data from multiple tables all with same structure but different data
  14. mysql query show multiple tables from one ID column
  15. How to find non-existing data from another Table by JOIN?
  16. LEFT JOIN only first row
  17. How does MySQL’s ORDER BY RAND() work?
  18. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  19. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  20. Select One Element in Each Row of a Numpy Array by Column Indices [duplicate]
  21. Compare only day and month with date field in mysql
  22. MySQL – SQL_BIG_SELECTS
  23. MySQL INNER JOIN select only one row from second table
  24. SQL SELECT from multiple tables
  25. how to use a like with a join in sql?
  26. Insert data into table with result from another select query
  27. How to use Table output from stored MYSQL Procedure
  28. MySQL ORDER BY rand(), name ASC
  29. Does a break statement break from a switch/select?
  30. MySQL Multiple Joins in one query?

Leave a Comment