This topic is locked

Filter a table

5/17/2008 11:21:36 AM
PHPRunner General questions
C
cocomunga author

Hi All. I have set up a database cataloguing my music collection. I have Album, Artist, Song title amongst other feilds. I would like to sort the display to show artist and album , however there are multiple entries for each album (for each song). I would like to filter the albums feild so that it only returns the album once (and then I can have a master-detail relationship mto show all tracks in that album). how do I filter the album column to display each album only once? Can you make it display only unique entries?

C
cocomunga author 5/17/2008

Hi again.

I have been looking around and I think I may need to use the select distinct or select unique option. but I am not sure how to enter the information on the Edit SQL Query page. Anyone able to help me out. Many thanks

Ccoc

J
Jane 5/20/2008

Hi,
switch to SQL mode and edit your SQL query manually on the Edit SQL query tab.