CODEWITHSUNDEEP
mysqlsqlselectjoininner-join
user3673198
user3673198

Reputation: 59

error 1066 while joining 3 tables

Now have the following problem. I am trying to get data from 3 tables using the following query.

SELECT Message, Name
FROM message, users
LEFT JOIN user_message ON ID = Message_id
LEFT JOIN user_message ON ID = User_id
WHERE user_message.status = 1
LIMIT 0 , 30

And here I am getting error 1066 what am I missing?

Upvotes: 1

Views: 61

Answers (2)

Saharsh Shah
Saharsh Shah

Reputation: 29051

Try this: 

SELECT m.Message, u.Name
FROM message m
INNER JOIN user_message um ON m.ID = um.Message_id
INNER JOIN users u ON u.ID = um.User_id
WHERE um.status = 1
LIMIT 0, 30;

Upvotes: 1

웃웃웃웃웃
웃웃웃웃웃

Reputation: 11984

You need to give alias and try like this

SELECT t1.Message, t2.Name
FROM message as t1
LEFT JOIN user_message as t2 ON t2.ID = t1.Message_id 
LEFT JOIN users as t3. ON t3.ID = t2.User_id
WHERE t3.status = 1
LIMIT 0 , 30

Upvotes: 0

Related Questions