Hi Ryan

Dont forget the as

cast(-1 as integer) AS a,
cast('' as varchar(64)) AS b,

Adam





--- In firebird-support@yahoogroups.com, "sllimr7139"
<_rmcontrols@m...> wrote:

> I've scanned through the news groups for a hint as to what I'm doing
> wrong but I can't for the life of me figure it out.
>
> Here is my SQL statement:
>
> select
> loc.locationname,
> pg.programgroupindex,
> pg.programgroupname,
> prog.programname
>
> from locations loc
> join programgroups pg on pg.locationid = loc.locationid
> join programs prog on prog.programgroupid = pg.programgroupid
>
> where loc.locationid=8
>
> union all
>
> select
> loc.locationname,
> cast(-1 as integer) a,
> cast('' as varchar(64)) b,
> nonprog.nonprogramstat
>
> from locations loc
> join nonprograms nonprog on nonprog.locationid = loc.locationid
>
> where loc.locationid=8
>
> order by
> 2, 3, 4
>
> I found the CAST statement trick as posted earlier by Helen, but for
> some reason I'm still getting the error message Data type unknown.
>
> Why is that?
>
> Even if I modify the statement to only include the first two

columns I

> still get the error message.
>
> Any insight would be great...
>
> I'm running FB 1.5.2
>
> Ryan.