SELECT

ST.First_Name AS Student_First_Name,

ST.SURNAME AS Student_Surname,

ST.STKEY,

ST.FAMB AS Alternative_Family_ID,

DF.Name_A AS Parent_A_First_Name,

DF.SURNAME_A AS Parent_A_Surname

 

FROM ST INNER JOIN DF ON ST.FAMB = DF.DFKEY

WHERE NOT FAMB = '' AND ST.STATUS = 'FUT'