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!

SQL 'distinct' ignored?

Status
Not open for further replies.
Hypermommy

Hypermommy

Programmer
May 23, 2003
75
US
Was trying to run a query in the CSP Query Builder, namely:

select distinct si_progid from ci_infoobjects

Expected to get one entry for each different si_progid in ci_infoobjects but the first couple were CrystalEnterprise.Folder and then the next several were CrystalEnterprise.FavoritesFolder and so on. So, obviously the "distinct" in my query was not processed the same as what I'm used to. Is there a different way to get a distinct listing?

Thanks.

-= Hypermommy =-
 
Status
Not open for further replies.

Similar threads

JScannell
  • Locked
  • Question
SQL Connection Issues when Programmatically running Crystal in vb.net
Replies
1
Views
109
JScannell
JScannell
CoachGBT
  • Locked
  • Question
Connection to remote SQL Server
Replies
1
Views
52
Turkbear
Turkbear
ratzo02
  • Locked
  • Question
Stuck - need to remove HTML tags and text either in SQL or using a formula within the report
Replies
3
Views
137
hilfy
hilfy
deborahyr
  • Locked
  • Question
How can I run a SQL statement using Crystal 2008 report?
Replies
2
Views
56
IdoMillet
IdoMillet
thethuthinnang
  • Locked
  • Question
SQL for Multiple Databases?
Replies
1
Views
41
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top