seeking a little help

[Jocka]

Ok, straight to the point. I'm searching for "A" between one zip code and another zip code. But I have to go through B to do it.

The problem is I say "SELECT bid FROM btable WHERE zip IN ('55555','55554,'55553,'55552,'55551')" and then I have the B information from the zip search. Now A gets it's information judging by bid. HOWEVER, I don't want to have it list out like this:

b1-a1
b1-a2
b1-a3
b2-a1
b2-a2
b3-a1
b4-a1

See what I'm saying? I don't want to draw out each A for the b. I want to draw out by the latest A regardless of the 'bid' ..

I know some of you are confused. I just confused myself a little.
The next best thing to do is save the 'bid' and 'zip' to A but I'd rather not. I can if I HAVE to but again, i'd rather not.

There may be a way to do it with MYSQL alone but I'm not real good with MYSQL.

[Psycho]

I think you need to restate your question. Is the list above is a representation of the results you woud get from your query? Are you trying to get the unique values of the 2nd part of those results.