Subject Re: SQL Question
Author Adam
Hi Daniel,

You can join to the same table several times as long as you use the
table name alias


select *
from table1 a
join table2 b on and = :param
join table2 c on


You can also move some the condition to the join because on 1.5 it will
sometimes help the optimiser.