HughFreiden
MIS
I have a SQL left-outer link. However I only want the first record found in the selection query. How can I "skip" over the remaining matching records in the Select Query?
THANX
THANX
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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rid of duplicate records in one-to-many (recs 2-??)
- Thread starter HughFreiden
- Start date
- Status
Hi hughfreiden,
There are so many options to do this.
e.g.
1. U can put that record in group header and supress the details part . or
2. U can write a query in sql designer ( selecting rownum=1)
and then create report from that query
Hope it helps
Raj28...
There are so many options to do this.
e.g.
1. U can put that record in group header and supress the details part . or
2. U can write a query in sql designer ( selecting rownum=1)
and then create report from that query
Hope it helps
Raj28...
- Thread starter
- #3
HughFreiden
MIS
Thanx for the help. ur 2nd answer seems to be the right way, re: from select statment. However I am a novice using sql command and where exactly to enter them in Crystal. Could you explain in more detail the commands in the sequel statement.
Much obliged
Hugh
Much obliged
Hugh
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question
- Locked
- Question