Hello Friends,
I want to get the information of the record(s) where SmallImage(Field Name) must be unique. For this i'm using the following query. Is it right or not if not plz make it correct
Select * From Gallery1 Where SmallImage in (Select Distinct SmallImage From Gallery1 Where Active=1)
Loading
Guest UserPosted Jan 7, 2008, 6:55 PM
SmallImage,BigImage,Address,City
FROM
Gallery1
Blocked AccountPosted Jan 7, 2008, 5:40 AM
Manoj BishtPosted Jan 7, 2008, 5:11 AM
I've to bring four fields........
ID,SmallImage,BigImage,Address,City
Blocked AccountPosted Jan 7, 2008, 5:02 AM
Your inner query is working fine and it gives the unique SmallImage. But when outer query fires then it will not give the correct result.
Tell me the total fields u want in the query result.
Happy Coding!!