mysql select id and name from other table and join query

by 
select task.id, task.name, proj.id, proj.name
from tasks task left join projects proj on proj.id=task.project_id;

Using left join ensures you get something even if there is no record in the projects table. If you want to ensure coherency, you may do

select task.id, task.name, proj.id, proj.name
from tasks task, projects proj
where proj.id=task.project_id;

More Related Contents:

  1. INSERT INTO SELECT statement with more columns which is not in another table
  2. multiple query same table but in different columns mysql
  3. How can I make SQL case sensitive string comparison on MySQL?
  4. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  5. 1052: Column ‘id’ in field list is ambiguous
  6. How to split the name string in mysql?
  7. How to do a batch insert in MySQL
  8. Count the occurrences of DISTINCT values
  9. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  10. Cumulative sum over a set of rows in mysql
  11. Set NOW() as Default Value for datetime datatype?
  12. Add Auto-Increment ID to existing table?
  13. MySQL SELECT DISTINCT multiple columns
  14. How to copy a row and insert in same table with a autoincrement field in MySQL?
  15. SQL DELETE with JOIN another table for WHERE condition
  16. mysql trigger stored trigger is already used by statement which invoked stored trigger
  17. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  18. Using group by on two fields and count in SQL
  19. Can MySQL convert a stored UTC time to local timezone?
  20. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  21. mysql update query with sub query
  22. What is the difference between the backtick and the square bracket in SQL statements?
  23. MySQL CONCAT returns NULL if any field contain NULL
  24. Does Order of Fields of Multi-Column Index in MySQL Matter
  25. Integrity constraint violation: 1452 Cannot add or update a child row:
  26. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  27. What does SQL Select symbol || mean?
  28. MySQL optimizing INSERT speed being slowed down because of indices
  29. SQL query with avg and group by
  30. Convert SQL Server query to MySQL [duplicate]

Leave a Comment