<div dir="ltr">Is it valid to specify a SELECT statement as part of a JOIN clause?<div style="style"><br /></div><div
style="style">Forexample:</div><div style="style"><br /></div><div style="style">SELECT table1.f1, table1.f2 FROM
table1</div><divstyle="style">INNER JOIN </div><div style="style">(SELECT table2.f1, table2.f2 FROM table2) table_aux
ONtable1.f1 = table_aux.f1</div><div style="style"><br /></div><div style="style">Respectfully,<br /></div><div
style="style">JorgeMaldonado</div></div>