|
| |
|
|
truwebs
Posts: 80
Joined: 7/10/2006
Status: offline
 |
Distinct Order By Help Needed - 5/2/2007 0:31:48
In an application I have a datalist with a gridview inside a datalist template. The gridview is bound to the datalist select.
When I run the following some records duplicate. But without the [Catalog].catID and Order By in the Select it works fine. What do I need to change to get this to work right with the Order By DESC?
DATALIST SELECT
SELECT DISTINCT Images.imgName, [Catalog].subID, [Catalog].imgID, [Catalog].catID FROM (([Catalog] INNER JOIN CatalogImage ON [Catalog].catID = CatalogImage.catID) INNER JOIN Images ON CatalogImage.imgID = Images.imgID) WHERE ([Catalog].subID = ?) Order By [Catalog].catID DESC
GRIDVIEW SELECT
SELECT [Catalog].catID, [Catalog].catNum, [Catalog].catPrice, [Catalog].catDescription, Vendors.venName, Images.imgName FROM (([Catalog] INNER JOIN Images ON [Catalog].imgID = Images.imgID) INNER JOIN Vendors ON [Catalog].venID = Vendors.venID) WHERE ([Catalog].imgID = ?)
TRU
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
