Coresponding rows

[scraff]

I have a table called 'buddies'

it just has the fields: 'buddyask' & 'buddyacept'

i need a query that will get all the entries that have 'buddyask' = $userid but also where 'buddyacept' in a different entry is the same as 'buddyask' in the first entry and vica versa.

This is because person 1 (person 1 is who is logged in) will ask person 2 to become buddies and then person 2 will ask person 1 to become buddies which will create two different records?

e.g.:

'buddyask' | 'buddyacept'

---

1...............|...............2
2...............|...............1

It will only bring up a result if there are these two corespondings rows. where id=1 is the person logged in and running the query.
How do i do this??Thanks

[paulnaj]

Something like ...

SELECT *
FROM buddies
JOIN buddies AS buddies2 ON ( buddies.buddyask = buddies2.buddyacept )

Paul 🙂