用于从不同表中检索的SQL语法？

Hi I have two tables User and Pictures im trying to pull the pathname from my pictures table (userid=1) is the same in both related with pk, but Im unsure how to select firstname etc from user table and select picturepath from pictures table? Hi I have two tables User and Pictures im tryin