I have a single table,
Issue. This table has Id and ChildId columns.
============= Id | ChildId 1 | NULL 2 | 3 3 | NULL 4 | 1 5 | NULL 6 | NULL =============
I need to select from this table so that the parent row is returned if it exists else return the child row. So selecting from every row would get:
============= Id | ChildId 4 | 1 2 | 3 2 | 3 4 | 1 5 | NULL 6 | NULL =============
I know that this table layout is not good (using ChildId instead of ParentId) but I cannot change the scheme unfortunately.
If you know how to return this data that would be great. Thanks in advance.