SQL query to return unique output based two fields from one table

[Jabeen]

Hi Guys,

My problem is I want SQL query to return unique output based on fields from two tables.


I have a table tag_phto which is a join table and has two fields: tag_Id and Phto_Id.

I have to create a page which will have a list of all tags and a thumbnail against each tag in the table.But I only have to show each tag only once and a different photo for each tag.

Can you able to help me to solve this issue?..

[Modifier]

Hi ,

Have you tried below method ? if not then try it.This method will definitely give you the desired output:

Query:

select tag_Id, Min(Phto_Id)
from tags_phto
group by tag_Id

[Praetor]

The answer for your problem is very easy.I also wanted the similar type of output.
At that time I used DISTINCT.The DISTINCT avoids the duplication in the output.

Syntax:

SELECT DISTINCT field1, field2..... from table_name

Example:

SELECT DISTINCT tag_id, phto_id from tag_phto

[Katty]

According to me this is because what you want is not achievable via SQL only. If I can understand your request correctly, what you are asking for is a page with the tag displays only once and all of the photos associated with that particular tag.

See below:

Tag PhtoTag
6 26
16
78


Your page will accept a Tag and independently get all of the phtoTag associated with that perticular tag .But SQL will give you a repeating value for Tag.