Hello,
How do I merge two queries together? The result of these queries will have to
be placed in a listbox. (I will just have to attach the listbox to the query)
SELECT a.EListItemName, b.EListItemName
FROM EListHierarchy AS a LEFT JOIN Rights AS b ON
a.EListItemName=b.EListItemName
WHERE b.EListItemName Is Null;
AND
SELECT EListItemName
FROM Rights r
WHERE r.EListItemName IN (SELECT DISTINCT a.EListItemName
FROM EListHierarchy a
INNER JOIN EListHierarchy b
ON a.EListItemName=b.EListItemParentName
Thanks,
Lyanne
L y a n n e R h e e z a C. O n g
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
