Need help with view creation

[dgillz]

I am trying to create a view in P.SQL 2000i and I am getting an error message when I hit OK or Applu, but not when I hit check syntax. here is my error message:

[Pervasive][ODBC Client Interface][Pervasive][ODBC Engine Interface]Syntax Error: CREATE VIEW &quot;IndyHeart&quot; AS SELECT mn_no, sb_no, dp_no, trx_dt as dist_dt, trx_amt as dist_amt, job_no FROM GLTRXHST_SQL unionSELECT mn_no<< ??? >>, sb_no, dp_no, dist_dt, dist_amt, job_no FROM APDISFIL_SQL

Any ideas where my problem is and why am I getting the error?


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[mirtheil]

You can't have Unions in Views with Pervasive.SQL 2000i.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[SundancerKid]

Why can't you have Union's in views? What do you use then?

Regards,

SDK