Hi,

I am trying to construct a very simple query from two tables and join the results into one list using SQL. The individual queries are as follows:

SELECT td_cycl_fold.CF_ITEM_NAME AS [Folder Name]
FROM td_cycl_fold
WHERE td_cycl_fold.CF_FATHER_ID=1234;

SELECT td_cycle.CY_CYCLE AS [Folder Name]
FROM td_cycle
WHERE td_cycle.CY_FOLDER_ID=1234;

At the moment I have to run these as separate queries but wonder if there was a way of running both at the same time and combining the results of both in a single column list output.

This is all being done within Access. Any help will be greatly appreciated.