How to filter self table entries - SQL

[Andrew2009]

My table is below

id | name | parent_id
1 | A |
2 | B | 1
3 | C |

I only want #3 (C) back. parent_id of #2 is the same as #1 (id field) so I don't want #1 and #2, only #3 back.

I'm using set selection group in Dialog is Initialized ER for a Find/Browser form grid.

Do you have any ideas how to complish this?

Thanks

 

[Chan Rana]

I dont think you can do it on base table. You will have to reprocess the data into new table and display from there.

Chan