> I am having problems using the union operator on two tables. Could
> somebody point out my mistake. Below is the SQL code.
>
> SELECT CAST LrgAddrData

Cast as what?

> FROM LargeAddress
> WHERE WPVBSQ < 20
> UNION ALL
> SELECT CAST (SmllAddrData AS CHAR)

"char" is not valid here - use, for example, CHAR(20)

> FROM SmallAddress
> WHERE WPVBSQ < 20
>
> Flamerobin shows the following error code :

Yeah well, that's another mistake too ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com