merge 2 crosstab tables without key

[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,

 

[John Spencer]

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
'====================================================

 

[inungh]

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 -

Thanks millions,