Skip to content
Advertisement

Use select filed result on LEFTJOIN string

I’m trying to use id_program result from the availability table inside a string in LEFTJOIN, is it possible?

I tried using this {post.id_program} but its not working.

EDIT: http://sqlfiddle.com/#!9/aeb4a7/3

Advertisement

Answer

I see two ways..

Using CONCAT():

With REPLACE():

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement