merge 2 crosstab tables without key

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

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

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top