Get data from joined table in mysql

Question

Please check the image.

Here i have 2 table. One is post table and another is fevorite table. Both has primary key and post_id is FOREIGN_KEY in fevorite table.

Now my needs are:

Select post_id list from fevorite table WHERE fevorite_by=2.
Using this post_id list get post details (post_title,created_by, ...) from post table.

I need all of those things in single query. Thanks in advance.

please add a comment before giving a downvote.

Md. Sajedul Karim
– Md. Sajedul Karim

2016-05-23 18:12:46 +00:00
Commented May 23, 2016 at 18:12 — Md. Sajedul Karim
– Md. Sajedul Karim, Commented May 23, 2016 at 18:12

Arulkumar · Accepted Answer · 2016-05-23 18:18:30Z

Use sub query to get your result:

SELECT * FROM Post WHERE post_id IN ( SELECT post_id FROM fevorite WHERE fevorite_by = 2)

Or you can do it by JOIN

SELECT P.* FROM Post P JOIN fevorite F ON F.post_id = P.post_id WHERE F.fevorite_by = 2

Collectives™ on Stack Overflow

Get data from joined table in mysql

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related