Select Query Question

[esengul]

i have a select query that shows everything from 2 tables have inner join. Query Results like:

tableA tableB
A A1
A A2
A A3
B B4
B B5
B B6
.
.
.
What i want to do is , i want to eliminate the first records of Table B (A1 and B4). Is there anyway to do that?

 

[sfreeman]

You actually want to delete the first record of each alpha group?

Or do you just want the query not to show them in the resulting recordset?

Sam_F
"90% of the problem is asking the right question.

 

[esengul]

I dont want the query not to show them in the resulting recordset?