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!

Select DISTINCT pages

Status
Not open for further replies.
epkiran

epkiran

Programmer
Jun 26, 2001
7
SE
How do I use DISTINCT (or whatever) to get DISTINCT Page_no?

A page can be re-used in another course, and I only want to list pages in the chosen course.....now I get a row with the page from every course it is used in....

SELECT p.Page_No, p.OriginalCourse_No, p.Summary
FROM CC_CoursePageView p INNER JOIN
PageObject po ON p.Page_No = po.Page_No
WHERE (po.MediaType_No = '11') AND (po.TechLevel = '3') AND (p.OriginalCourse_No = '337')

Regards
Irene
 
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
591
SashaBuilder3
SashaBuilder3
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
447
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
327
grnzbra
grnzbra
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
194
Auguy
Auguy
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
2K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top