Thread: Conditional JOIN in Stored Procedure

I want to include a JOIN in my stored procedure based on a boolean parameter passed to it.

I have tried this, but it is giving an error saying I have incorrect SQL syntax when I try and execute it.

Code:

FROM user_tasks
LEFT JOIN user_tasks_links ON (user_tasks_links.todoref=user_tasks.todoref AND user_tasks_links.userref=@userref)
LEFT JOIN users ON users.userref=user_tasks.cur_user
IF (@CompanyOwn=False AND @CompanyBelow=False) THEN LEFT JOIN visitors ON visitors.userref=user_tasks.visitorref;
END IF;

Anyone know if this is possible?

Try using a CASE statement instead.

Nope...Get the same problem.

It doesn't seem to like it in the middle of a statement.

Scratch that, mate...it's not possible to use in the FROM clause. I'm thinking you're going to need a dynamic query.

Originally Posted by jmurrayhead

Scratch that, mate...it's not possible to use in the FROM clause. I'm thinking you're going to need a dynamic query.

Can you create a dynamic FROM clause or do you have to create the whole SQL query from scratch?

I don't think you can do anything like that in the FROM clause unless you're building an actual string that gets executed in the procedure, you build your query in code, or you use my dynamic stored procedure example in the SQL Code Examples forum.