Syntax error in FROM clause union query

[John1Chr]

Can you see the issue? Not sure why I am getting the error.

Select TABLE1.CTRRBVALUE,
TABLE1.CFATTRB,
TABLE1.DESCR,
TABLE1_1.CFATTRB,
TABLE1_1.CTRRBVALUE,
TABLE1_1.DESCR
from TABLE1
inner join TABLE1_1
where 0=1
UNION ALL Select
TABLE1.CTRRBVALUE,
TABLE1.CFATTRB,
TABLE1.DESCR,
TABLE1_1.CFATTRB,
TABLE1_1.CTRRBVALUE,
TABLE1_1.DESCR
from TABLE1
inner join TABLE1_1
TABLE1. CTRRBVALUE = substr(TABLE1 . CTRRBVALUE , 1, 2) and
TABLE1_1. CFATTRB = 'ACTIVITY' and
TABLE1.CFATTRB = 'PROGRAM';

 

[lameid]

Looks like your joins are missing the 'ON' Keyword and missing parts. Additionally it looks like you forgot to start your Where clause with Where in the second select.

 

[Andrzejek]

Plus:[blue]
Select TABLE1.CTRRBVALUE,
TABLE1.CFATTRB,
TABLE1.DESCR,
TABLE1_1.CFATTRB,
TABLE1_1.CTRRBVALUE,
TABLE1_1.DESCR
from TABLE1
inner join TABLE1_1
where 0=1[/blue]
UNION ALL [red]Select
TABLE1.CTRRBVALUE,
TABLE1.CFATTRB,
TABLE1.DESCR,
TABLE1_1.CFATTRB,
TABLE1_1.CTRRBVALUE,
TABLE1_1.DESCR
from TABLE1
inner join TABLE1_1
TABLE1. CTRRBVALUE = substr(TABLE1 . CTRRBVALUE , 1, 2) and
TABLE1_1. CFATTRB = 'ACTIVITY' and
TABLE1.CFATTRB = 'PROGRAM'[/red];

You should be able to run the BLUE and RED selects independently, but can you?

In the BLUE select you join 2 tables on what? And the WHERE 0 = 1 will never give you any results back (unless in some universe 0 equals 1 )

Have fun.

---- Andy