sql involving three tables

[puzzleofurheart_23]

hello..i can't get my code to work..here's the details
i have three tables

table 1 :Company_Profile
fields: address,comp_no

table 2: Project_Info
fields: pro_no, title

table 3: Company_Project
fields : com_no, pro_no

I want to link the tree tables..I have a search button..the input is address..
So, I need to get the pro_no and comp_no of the address given including the title..

this is my current code:

adodc1.recordsource = "select * from address, a.comp_no, b.pro_no from Company_Profile,Company_Profile a,Project_Info b where address = txt2.text and a.comp_no = comp_no and b.pro_no = a.pro_no"
adodc1.refresh..


please..i Need it so bad..
tnx..