mysql query using joins -get data from multiple tables

Question

SELECT posts.content, posts.title, owners.firstname, 
owners.lastname, owners.email 
FROM posts,owners JOIN posts ON posts.owner_id = owners.owner_id;

I am trying to display (content, title, firstname, lastname, email) from both the tables (owners with the fields -owner_id,firstname,lastname,email and posts with the fields-id,owner_id,content,title,created_time,updated_time).

It shows,

'Not unique table/alias' error.

What's the solution to this? Thanks in advance.

Rahul · Accepted Answer · 2017-01-11 10:42:34Z

1

Your query FROM part went wrong. You are kind a mixing old style and ANSI style JOIN syntax. It has to be like

FROM posts JOIN owners ON posts.owner_id = owners.owner_id;

answered Jan 11, 2017 at 10:42

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Naveed Ramzan · Accepted Answer · 2017-01-11 10:43:24Z

1

SELECT posts.content, posts.title, owners.firstname, owners.lastname, owners.email 
FROM owners 
JOIN posts ON posts.owner_id = owners.owner_id;

answered Jan 11, 2017 at 10:43

Naveed Ramzan

3,5893 gold badges27 silver badges33 bronze badges

Comments

krishna Prasad · Accepted Answer · 2017-01-11 10:49:07Z

0

Your query seems to be wrong after FROM part, correct query is:

SELECT posts.content, posts.title, owners.firstname, owners.lastname, owners.email FROM posts JOIN owners ON posts.owner_id = owners.owner_id;

You can see more about JOIN in the link

answered Jan 11, 2017 at 10:49

krishna Prasad

3,8521 gold badge36 silver badges49 bronze badges

Collectives™ on Stack Overflow

mysql query using joins -get data from multiple tables

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related