>My title for this message is not very clear, I am sorry, I just could not define it in one line.
>
>In my SQL I have the following left join:
>
>

>left join &cParentAlias. on cPrefix + &cParenField. = &cChildField.
>

>
>But sometimes I have no need for this left join, that is, there is no cParentAlias and the rest. How can I make this Left Join to be ignored by SQL Select?
>
>Thank you.

if Something
text to m.lcLeftJoin textmerge noshow
 left join <<cParentAlias>> on <<cPrefix>><<cParenField>> = <<cChildField>>
endtext
else
 lcLeftJoin = ''
endif
select ..... &lcLeftJoin

Cetin