djmason_2001 (10/9/2012)
Hithank you for your response
In your last part of the query i dont get what this is meant to do
I understand you want me to select certain columns/titles.
but the on query2.somcolumns is confusing me
SELECT WhateverYouWant
FROM Query1
INNER/LEFT OUTER/FULL OUTER JOIN Query2
ON Query2.somecolumns = Query1.somecolumns
ORDER BY SomethingMeaningful
--------------------------------------------------------------------------------
I've no idea how you might join these two CTE's together because I can't see your data - only you know that. "somecolumns" is a placeholder for what the real columns might be.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]