Is there a specific join to bring in all data from two queries? Thanks, Melinda
M Melinda Mar 9, 2007 #1 Is there a specific join to bring in all data from two queries? Thanks, Melinda
S Stefan Hoffmann Mar 9, 2007 #2 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 <--
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 <--
