Circular related issues--help

Circular problem--help
For advice
Table 1:
Db_1

Fid
Fup
Name
---------------
Table 2:
Db2

Fid
Subject
---------------
FID (table db_1) =fid (table db_2)
--------------------------------
I want to loop through the name of fup=0 in table 1 and the subject associated with name.


————————————————————————
|
| name1 | name2 | Name3 | Name4
|subject Subject Subject Subject
|subject Subject Subject Subject
|subject Subject Subject Subject
|subject Subject Subject Subject
|subject Subject Subject Subject
|subject Subject Subject Subject
|

------Solution--------------------
Select Db_1.name,db_2.subject from db_1,db_2 where Db_1.fid=db_2.fid and Db_1.fup=0
GROUP BY Db_1.name,db_2.subject

