merge 2 crosstab tables without key

  • Thread starter Thread starter inungh
  • Start date Start date
I

inungh

I need merge 2 crosstab queries without keys.
Is it possible?

Because the number of column heading and name are unknown before
running crosstab query, I use following SQL

Select A.*, BCrossTab.* From ACross A Inner Join on A.key =
BCrossTab.key

which includes the all keys fields.

Is it possible to have the result only have one table keys?


Your information is great appreciated,
 
Not unless you specify the fields in the select clause. So the answer
(as far as I know) is NO.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Not unless you specify the fields in the select clause.  So the answer
(as far as I know) is NO.

'====================================================
  John Spencer
  Access MVP 2002-2005, 2007-2009
  The Hilltop Institute
  University of Maryland Baltimore County
'====================================================









- Show quoted text -
Click to expand...

Thanks millions,
 
Back
Top