Depends what you want SELECT DISTINCT 'QUERY1' AS SOURCE, A.txtName, Null AS Col3 FROM ApprovalGroup As AG INNER JOIN UserGroups AS UG ON AG.txtInternetNum = UG.txtInternetNum AND AG.intViewGroup = UG.lngGroupNum INNER JOIN Account AS A ON UG.txtAccountNum = A.txtAccountNum AND UG.txtInternetNum = A.txtInternetCompNum WHERE (AG.txtUserID = 'tester1') AND (AG.txtInternetNum = '9570') UNION ALL SELECT DISTINCT 'QUERY2', a.txtName, t.blnsent FROM transactions t INNER JOIN account a ON t.txtAccountNum = a.txtaccountnum WHERE a.txtinternetcompnum = '9570' AND t.dtecycledate = ( SELECT MAX(t1.dtecycledate) FROM transactions t1 WHERE t1.txtinternetnum = '9570') AND t.blnsent = 0 ORDER BY a.txtName-- OR 1 Row perSELECT * FROM ( SELECT DISTINCT 'QUERY1' AS SOURCE, A.txtName, Null AS Col3 FROM ApprovalGroup As AG INNER JOIN UserGroups AS UG ON AG.txtInternetNum = UG.txtInternetNum AND AG.intViewGroup = UG.lngGroupNum INNER JOIN Account AS A ON UG.txtAccountNum = A.txtAccountNum AND UG.txtInternetNum = A.txtInternetCompNum WHERE (AG.txtUserID = 'tester1') AND (AG.txtInternetNum = '9570') ) AS AINNER JOIN ( SELECT DISTINCT 'QUERY2', a.txtName, t.blnsent FROM transactions t INNER JOIN account a ON t.txtAccountNum = a.txtaccountnum WHERE a.txtinternetcompnum = '9570' AND t.dtecycledate = ( SELECT MAX(t1.dtecycledate) FROM transactions t1 WHERE t1.txtinternetnum = '9570') AND t.blnsent = 0) AS BON A.txtName = B.txtNAme ORDER BY a.txtName-- Take your pick
Brett8-)SELECT POST=NewId()