Query Help

[gnboston]

I am trying to bring back an item and its corresponding item that it may or may not have. For example, there are PRFs and PIFs. A PRF may or may not have a corresponding PIF and a PIF may or may not have a corresponding PRF. Both of these items are in the same table. I would think a self full outer join would do the trick, however; Access does not support full outer joins. Can anyone assist me?

[weekend00]

you don't need any join. just a simple query because they are in same table:
select PRF, PIF from mytable

[gnboston]

Each PRF and PIF has its own unique ID and row. The way you know if they are associated or not is if the Associated PIF column and Associated PRF column are populated with the others unique ID. Make sense?