Urgent problem - Resord Set

[Andrew]

How do I select the First Record only based on MemberID

The layout is PhotoID,MemberID,Title

1, 666, blah1
2, 555, blah2
3, 666, blah3
4, 777, blah4
6, 777, blah5
7, 999, blah6
8, 444, blah7

So the result Im after is

1, 666, blah1
2, 555, blah2
4, 777, blah4
7, 999, blah6

Table is called TbPhoto (Using Access)

[Oscar Santiesteban Jr.]

I would do this via cursors, which is never good but.....what can you do.

Create a temp table.
define the cursor
fetch cursor
while status <> -1
if the 3-digit number is not in temp table
insert the record into temp table
fetch next
end while loop
SELECT * FROM temp_table

I assume that you also want 8, 444, blah7 should be in your
result set.

Oscar...

"Andrew" <an****@nospam.com> wrote in message
news:rF***************@newsfep1-gui.server.ntli.net...

How do I select the First Record only based on MemberID

The layout is PhotoID,MemberID,Title

1, 666, blah1
2, 555, blah2
3, 666, blah3
4, 777, blah4
6, 777, blah5
7, 999, blah6
8, 444, blah7

So the result Im after is

1, 666, blah1
2, 555, blah2
4, 777, blah4
7, 999, blah6

Table is called TbPhoto (Using Access)

[Erland Sommarskog]

Andrew (an****@nospam.com) writes:

How do I select the First Record only based on MemberID

The layout is PhotoID,MemberID,Title

1, 666, blah1
2, 555, blah2
3, 666, blah3
4, 777, blah4
6, 777, blah5
7, 999, blah6
8, 444, blah7

So the result Im after is

1, 666, blah1
2, 555, blah2
4, 777, blah4
7, 999, blah6

Table is called TbPhoto (Using Access)

SELECT PhotoID, MemberID, Title
FROM TbPhoto a
JOIN (SELECT PhotoID = MIN (PhotoID), MemberID
FROM TbPhoto
GROUP BY MemberID) AS B ON a.PhotoID = b.PhotoID
ORDER BY a.PhotoID
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Anith Sen]

Do:

SELECT *
FROM tbl
WHERE PhotoId = (SELECT MIN(t1.PhotoId)
FROM tbl t1
WHERE t1.MemberId = tbl.MemberId);

--
-- Anith
( Please reply to newsgroups only )