MYSQL AND PHP joining 2 queries -

query show post made users.

$sql = "select b.title, b.article, b.article_id, b.posted_by, b.users_id,date_format(updated, '%m-%d-%y %l:%i:%s') updated , u.user_pic_path, u.user_id, u.username, i.filename         users u          inner join blog b         on b.posted_by = u.user_id         left outer join images          on b.image_id = i.image_id         b.users_id = ?         , b.posted_by = ?         order updated  desc" 

query select users friends.

$sql = "select f.status,u.user_id, u.username, u.email, u.user_pic_path       users u, friends f             case       when f.friend_one =?        f.friend_two = u.user_id         when f.friend_two = ?        f.friend_one= u.user_id        end        , f.status = 2"; 

so want show blog post made users frineds. have join both join both queries. i'm stuck, have no clue how that.

you can 'where id_users in (select())':

posts query id_users in (friends query).

something this:

$sql = "select b.title, b.article, b.article_id, b.posted_by, b.users_id,date_format(updated, '%m-%d-%y %l:%i:%s') updated , u.user_pic_path, u.user_id, u.username, i.filename         users u          inner join blog b         on b.posted_by = u.user_id         left outer join images          on b.image_id = i.image_id         b.users_id in (            select u.user_id            users u, friends f                       case            when f.friend_one =?             f.friend_two = u.user_id              when f.friend_two = ?             f.friend_one= u.user_id             end             , f.status = 2         )         , b.posted_by = ?         order updated  desc"