PDO - select data from two tables

Question

I want to take all the data from two tables with the same user_id, but I don't know what type of join to use and I want to be sure with the syntax of the query.

"users" table:

"schedule" table:

A SQL query goes into a bar, walks up to two tables and asks, "Can I join you?" -[Adam Neal](http://stackoverflow.com/questions/234075/what-is-your-best-programmer-joke) — user7393973, Feb 15 '17 at 11:47
@Your Common Sense I appreciate the edit but I specified clearly that I want to be sure with the syntax. — Kent Abrio, Feb 15 '17 at 11:56
sorry my fault, i didnt specify that ill be using it on a php code, your link is for pure sql syntax. — Kent Abrio, Feb 15 '17 at 12:09
Joins are SQL thing so I have no idea what PHP code you are talking about — Your Common Sense, Feb 15 '17 at 12:18
yah but some syntax there are not the same when you incorporate it to a php function. it might have some slight difference that's why i want it to be specific. — Kent Abrio, Feb 15 '17 at 12:26
If you have no idea how to run an SQL query in PHP that's another question and it should be asked separately. Ask one question at a time — Your Common Sense, Feb 15 '17 at 12:28

score 1 · Accepted Answer · edited Feb 15 '17 at 11:48

1

Here's a simple LEFT JOIN example:

SELECT * FROM `users` LEFT JOIN `schedule` ON `users`.`userid` = `schedule`.`user_id` 
WHERE `users`.`userid` = ?

this will collect everything from both tables and then you can output it accordingly.

edited Feb 15 '17 at 11:48

Your Common Sense

156,878
40
214
345

answered Feb 15 '17 at 11:47

Option

2,605
2
19
29

PDO - select data from two tables

1 Answers1