Jion problem

Hallo!

I have two tables. They are relationship with ID (name_id).

table1: names

name_id name

1 Bob
2 Smith

table2: books

book_id name_id book

1 1 PHP

2 1 MySQL
3 1 Javascript

How do I can join them?

If I test the choice

SELECT name, book FROM names LEFT JOIN books ON names.name_id=books.book_id ORDER BY names.name

Here I cannot get all books that they consist in Bob. I only get PHP book

Where the problem is?

You used the wrong column in the on clause.

SELECT name, book 
   FROM names left JOIN books 
      ON names.name_id = books.name_id 
 ORDER BY names.name

Hi,

You have to join column with same id like belowe,

SELECT name, book
FROM names left JOIN books
ON names.name_id = books.name_id
ORDER BY names.name