Join 2 Complex Queries To 1

hi there

anyone had an idea to join following 2 queries to 1????


----- QUERY 1 ---------------------------------------------
SELECT TMS_CaseF_2.Name AS TCDomain_0,
TMS_CaseF_3.Name AS TCDomain_1,
TMS.CaseF.Name AS TCFolder_2,
TMS_CaseF_1.Name AS TCFolder_3,
TMS.TestCase.Name AS TCName_4,
TMS_TestCase_1.Name AS TCName_5,
TMS.LogFolder.Name AS PlannedLogFolder_6,
TMS.Log.Name AS PlannedLog_7,
TMS.CaseResult.RecordedCaseName AS TCRecordedName_8,
TMS.TestPlan.Name AS Plan_9
FROM
(
(
(
(
(
(
(
(
(
(TMS.Build INNER JOIN TMS.LogFolder ON TMS.Build.UID =
TMS.LogFolder.Build)
INNER JOIN TMS.Log ON TMS.LogFolder.UID = TMS.Log.LogFolder
)
INNER JOIN TMS.CaseResult ON TMS.Log.UID = TMS.CaseResult.Log
)
INNER JOIN TMS.TestCase ON TMS.CaseResult.TestCase =
TMS.TestCase.UID
)
LEFT JOIN TMS.CaseF ON TMS.TestCase.Parent = TMS.CaseF.UID)
LEFT JOIN TMS.TestCase AS TMS_TestCase_1 ON TMS.TestCase.Parent =
TMS_TestCase_1.UID
)
LEFT JOIN TMS.CaseF AS TMS_CaseF_1 ON TMS_TestCase_1.Parent =
TMS_CaseF_1.UID
)
LEFT JOIN TMS.CaseF AS TMS_CaseF_2 ON TMS_CaseF_1.Parent =
TMS_CaseF_2.UID
)
LEFT JOIN TMS.CaseF AS TMS_CaseF_3 ON TMS.CaseF.Parent =
TMS_CaseF_3.UID
)
INNER JOIN TMS.TestPlan ON TMS.TestCase.TestPlan = TMS.TestPlan.UID
)
WHERE (((TMS.LogFolder.Name) Like 'TR1%')
AND ((TMS.Build.Name)='Planning_VD10A'))
ORDER BY TMS.CaseF.Name,
TMS_CaseF_1.Name,
TMS.TestCase.Name,
TMS_TestCase_1.Name;
-------------------------------------------------------------




----- QUERY 2 ---------------------------------------------
SELECT TMS.CaseResult.RecordedCaseName
FROM ((TMS.Build INNER JOIN TMS.LogFolder ON TMS.Build.UID =
TMS.LogFolder.Build)
INNER JOIN TMS.Log ON TMS.LogFolder.UID = TMS.Log.LogFolder)
INNER JOIN TMS.CaseResult ON TMS.Log.UID = TMS.CaseResult.Log
WHERE (((TMS.LogFolder.Name) Like 'VD%')
AND ((TMS.Build.Name)='VD10A IT_APP'));