Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Union and Union All

Status
Not open for further replies.
Hm786

Hm786

Programmer
Apr 5, 2001
88
US
Hi,

I have a question, does crystal 9.0 supports Union, Union All and subquries.

Thanks,
Hamida
 
Sort by date Sort by votes
Sure does. You can use real SQL.

I believe CR 7 and up supported UNIONS and UNION ALLS (CR 8/8.5 did), but not subqueries.

-k

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
281
Cpreston
Cpreston
AleXSR700
  • Locked
  • Question
How can I make variable that is re-defined per section and readable in same-section formula? 2
2
Replies
20
Views
686
AleXSR700
AleXSR700
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
178
socalvelo
socalvelo
DennisY
  • Locked
  • Question
A subscript must be between 1 and the size of the array.
Replies
10
Views
326
DennisY
DennisY
GCL2007
  • Locked
  • Question
Add leading ***** and a $ sign to check report 1
Replies
2
Views
117
GCL2007
GCL2007

Part and Inventory Search

Sponsor

Back
Top