joining with multiple rows?

wxdqz

New Member
Is there any way to join different columns on different conditions in one sql statement? for example,

select table1.*, table2.author, table2.title from table1 left join table2 using(recordId) left join table2 on(table1.recordTime=table2.otherTime)

I know this is not valid syntax (it's ambiguous) but is there any way to join different columns of the same table using a separate condition? does this question make any sense at all?
 
Back
Top