MySQL case statement

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nsteiner
    New Member
    • Dec 2008
    • 25

    MySQL case statement

    Hi guys
    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
    Thanks in advance
Working...