Please don't post questions again as a new thread. See my answer
to this under yoiur later post, "Full Outer Join dynamically"
> I found out that I need a Full outer join.. so can you help me with the code
> > I want to join tables on a certain join.. But i want to return all rows of
> > the tables ..
> > Say tableA and tableB
> > I want to retrieve all rows of A and B and have nulls where it does not
> > a matched record .
> > So dont I need to join ?
> > Thanks
> > > Cross join does not take join conditions, but if you ment any other join
> > > types then yes, it is possible. Put your select, from, and the rest of
> > > clauses into three or more varchar variables. Construct from clause
> > > cursor.
> > > Execute as follows:
> > > > I have multiple tables listed in a certain table say 'TABLELIST'
> > > > I want to do a cross join of all the tables in the ' TABLELIST' on a
> > > certain
> > > > join condition. There is a col say 'colmain' that has the same name in
> > all
> > > > tables..
> > > > How can i do this ?
> > > > Tablelist
> > > > Name
> > > > TableA
> > > > TableB
> > > > TableC
> > > > TableD
> > > > ...
> > > > So i want to join all these tables based on colmain
> > > > Thanks