Hi guys
Is it possible to use a CASE statement for a JOIN ?
Something like this:
Thanks in advance
Is it possible to use a CASE statement for a JOIN ?
Something like this:
Code:
SELECT tasks.taskid,jobs.jobid FROM tasks CASE WHEN tasks.taskid>100 THEN INNER JOIN jobs USING (taskid) ELSE INNER JOIN jobs ON tasks.lastjobid = jobs.jobid END