hi, does anyone know how can I combine these two select statements without the Union? Can it be made?
SELECT [Level 1].SON_ID as DAD_ID, [Level 3].SON_ID as SON_ID
FROM ([Level 1] INNER JOIN ([Level 2] INNER JOIN [Level 3] ON [Level 2].SON_ID = [Level 3].DAD_ID) ON [Level 1].SON_ID = [Level 2].DAD_ID) INNER JOIN [unique MIS4] ON [Level 3].SON_ID = [unique MIS4].SON_ID;
UNION
SELECT [Level 2].SON_ID as DAD_ID, [Level 3].SON_ID as SON_ID
FROM ([Level 1] INNER JOIN ([Level 2] INNER JOIN [Level 3] ON [Level 2].SON_ID = [Level 3].DAD_ID) ON [Level 1].SON_ID = [Level 2].DAD_ID) INNER JOIN [unique MIS4] ON [Level 3].SON_ID = [unique MIS4].SON_ID;