var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Union inside select
Im trying to select from a table that uses a union with little sucess. i get an sql syntax error.
NOTE: Everything inside the FROM clause works fine on its own.
Try it like this:
WITH temp1 as
something, something_else from temp1
I am getting a syntax error on that
Please post your entire query.
and your platform and db2 version...
CTE( WITH Construct) is not supported on mainframe till v7
Originally Posted by ARWinner
Visit the new-look IDUG Website
, register to gain access to the excellent content.
It's getting confused and thinks you're attempting to write a recursive statment.
Try using the TABLE keyword...
Also, think about using UNION ALL in preference to UNION unless there is a good reason to distinct your select.
from table (