Untitled

What should I use: inner join or 3 different queries?

SELECT member.*,member_photo.*,member_video.*

FROM (member

    INNER JOIN member_photo ON member.member_id = member_photo.member_id

)

INNER JOIN member_video ON member.member_id = member_video.member_id

       

SELECT member.*, member_photo.*

FROM member

INNER JOIN member_photo ON member.member_id = member_photo.member_id

 

SELECT member.*, member_video.*

FROM member

INNER JOIN member_video ON member.member_id = member_video.member_id

       

member1     photo1-of-member1   video1-of-member1

member1     photo2-of-member1   video2-of-member1

member1     photo3-of-member1   ...empty...

       

SELECT DISTINCT member.*,member_photo.*,member_video.* FROM (member INNER JOIN member_photo ON member.member_id = member_photo.member_id) INNER JOIN member_video ON member.member_id = member_video.member_id