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,
 

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

Similar Threads

Itereate cross tab query over another query 0
Insert a crosstab to temp table 4
crosstab query without calculations 4
Subquery Issue 1 5
Crosstab query as data source for update query 7
Make-table query with around 2 ml records taking too long 0
UNION and Crosstab query 5
dynamic crosstab query 2

Back
Top