SQL select statement 1

[Scrabble]

I have this query.

Select
1 "Topbottomflag"
a."row"
......

How can Get the 1 "TopbottomFlag" to stay in the SQL statement. After i edit the Show Sql and run the report the 1 "Topbottomflag" disappears. Is there any way that I can get this to stay. Or put it somewhere else. Also I need the 1 I believe because I'm going to have to UNION with it and put a 2 "TopbottomFlag"

Thanks

 

[synapsevampire]

Create a SQL Expression to handle the first select identifier of:

1 as Topbottomflag

The SQL you place AFTER the Union can have anything you'd like, but watch for where Crystal places the Topbottomflag SQL Expression within the CR built select so you match columns.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Scrabble]

Thanks, that worked.