two Queries

M

Melinda

Is there a specific join to bring in all data from two queries?

Thanks,
Melinda
 
S

Stefan Hoffmann

hi Melinda,
Is there a specific join to bring in all data from two queries?
Click to expand...
Yes, it is called a cross join. It returns the cartesian product of the
involved tables or queries:

SELECT A.*, B.*
FROM A, B


mfG
--> stefan <--
 

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

Creating a Chart on form from selected data in query. 0
Append Crosstab Query to Existing Table 0
How to implement two shifts per day with multiple teams 0
Corrupt? Scrolling while viewing two pages side by side, pages go wonky? 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
WordPad blocked content 2
MS time and billing template 1
One computer not wrapping vertical text 0

Top