SQL join problems

<i><b>Originally posted by : Terry Inniss (elk@caribsurf.com)</b></i><br />I have three tables that can be join but not by primary key. I have some inner joins to link them but my asp crashes on the said SQL statement. Can someone tell me what is the problem?<br />

<i><b>Originally posted by : iyyappan n iyer (iyyappan_n_i@hotmail.com)</b></i><br /><br />here is a sample for 3 table query:<br /><br />select * from table1,table2,table3 where table1.f1 = table2.f1 and table2.f1 = table3.f1<br />order by table1.f1,table2.f2 <br /><br />and so on<br /><br /><br />