select values from 2 tables with 1 query

[robs99]

hey,

ive got problem. im trying to kind of combine 2 tables in one query. ive searched and tried to look at examples but i didnt get it to work lets say i have 2 tables. one with posts which looks like this:

posts:

post_id, content, author

 

and one which saves the post-id of a flagged post and the user-id of the user who flagged it

flags:

post_id, user_id

 

what i want to do is show whether a post has been flagged or not in one query. lets say display the output like this:

post_id, content, author, flagged (flagged can be true or false)

 

is there a way to do is? sorry for sounding so confusing ive tried to find a solutions for the past 3 hours and my head is about to burst...

[HuggieBear]

Have you tried using SQL JOINS?

[HuggieBear]

I expect something like this is going to give you what you're after

 

   SELECT p.post_id, p.content, p.author, f.user_id
     FROM posts p
LEFT JOIN flags f
       ON p.post_id = f.post_id