FYI....the problem been solved now...cheers everyone...:rolleyes:

Thanks man...worked like a charm....cheers... : )

Thank you so much man...really appreciate your effort... 🙂

patrickmcginnis59 10839 (2/25/2014)

---

Here's a sample case expression that I would start out with with a pretend join because yours was a tad confusing to me, you'll get better help by...

Merge means I want to get all the 6 columns(3 on each table) in to a new table...

Okay…sorry guys for making you all so confused :w00t: I really didn't mean it...

Here is an example –

Select R1,R2,R3

From Database.table1 as table.x

Select C1,C2,C3

From Database.table2 as table.y

Now, I want to...

SELECT * FROM

(

SELECT datafields

FROM t1

UNION ALL

SELECT datafields FROM t2

) AS Anewtable WHERE t1.something = t2.something

Am I right here? I have to do the entire process in three tiers...almost 45 tables...

Thanks guys...its been solved now...:-D I still don't see the link on the Report Manager Site...but who gives a **** as long as its working...I have made the connections and...