Multiple selects

[bludlust586]

Hi all
I am working with SQL and currently I have two seperate queries. I would like to combine this into one query however I am not sure how to do it. I have pasted both of my queries below. Thanks for your time and any help....

Query One
SELECT
CYCL_FOLD.CF_ITEM_NAME, CYCLE.CY_CYCLE, CYCLE.CY_STATUS,CYCLE.CY_COMMENT, CY_USER_01, CY_USER_02
FROM
CYCL_FOLD
INNER JOIN CYCLE ON CYCL_FOLD.CF_ITEM_ID = CYCLE.CY_FOLDER_ID

WHERE
CYCL_FOLD.CF_ITEM_NAME = '@Request.TC_USER_01~'

Query Two
SELECT

TESTCYCL.TC_TEST_ID, TESTCYCL.TC_EXEC_DATE, TESTCYCL.TC_USER_01, TEST.TS_TEST_ID, TEST.TS_NAME, TESTCYCL.TC_STATUS,TEST.TS_DESCRIPTION, TC_USER_02

FROM

TESTCYCL

INNER JOIN TEST ON TESTCYCL.TC_TEST_ID = TEST.TS_TEST_ID

WHERE TC_USER_01 = '@Request.TC_USER_01~'

 

[bludlust586]

Hi all
I have combined the two selects however now i need to put a statment in eliminating duplicates. The field CY_CYCLE will have lots of duplicates so how can I say only display each occurence once?
Thanks for the help

SELECT
CYCL_FOLD.CF_ITEM_NAME, CYCLE.CY_CYCLE,CYCLE.CY_STATUS,CYCLE.CY_COMMENT, CY_USER_01, CY_USER_02,TESTCYCL.TC_TEST_ID, TESTCYCL.TC_EXEC_DATE, TESTCYCL.TC_USER_01, TEST.TS_TEST_ID, TEST.TS_NAME, TESTCYCL.TC_STATUS,TEST.TS_DESCRIPTION, TC_USER_02

FROM
CYCLE
INNER JOIN TESTCYCL ON CYCLE.CY_CYCLE_ID = TESTCYCL.TC_CYCLE_ID
INNER Join CYCL_FOLD ON CYCLE.CY_FOLDER_ID = CYCL_FOLD.CF_ITEM_ID
INNER JOIN TEST ON TESTCYCL.TC_TEST_ID = TEST.TS_TEST_ID


WHERE

CYCL_FOLD.CF_ITEM_NAME = '2005.02' OR TC_USER_01 = '2005.02'