Message:

This question already has answers here:

My Answer:
- How can an SQL query return data from multiple tables?
- SQL join: where clause vs. on clause

Here is an example of how to join two tables in MySQL and retrieve all entries from table 1:

sql

SELECT table1.*

FROM table1

LEFT JOIN table2 ON table1.id = table2.table1_id;

In this query, we are selecting all columns from table1 and using a LEFT JOIN to join table2 on the condition that the id column in table1 matches the table1_id column in table2. This will give us all entries from table1, regardless of whether there is a matching entry in table2.

Rate this post

5 of 5 based on 8522 votes

John Davidson

php - MySQL Join two Tables, give all entries of table 1