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?
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?