Select query in Frontpage is not working

[leifoet]

TableA = e.g. 10 records = names
TableB = e.g. 50 records = names + actions

I try to make a selection query to print a list als follows :

name record 1 from tableA
+ all reords from tableB with the same name 1

name record 2 from tableA
+ all reords from tableB with the same name 2

etc. for all the names

I have to mention the tableB but where and how ? I tried different inserts to become the listresult => only error meesages
fp_sQry="SELECT tableA.MId, tableA.Lname, tableA.Fname,
FROM tableA
ORDER BY tableA.Lname ASC"

Thanks for tips - Leifoet