Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Japie52
Starting Member
3 Posts |
 Posted - 2007-09-20 : 10:10:38
|
| I need to cross join two tables in MS Access. I have tried the CROSS JOIN statement but it returns an error. Appreciate any help |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-20 : 10:13:43
|
quote:
Originally posted by Japie52
I need to cross join two tables in MS Access. I have tried the CROSS JOIN statement but it returns an error. Appreciate any help
Post the query you usedMadhivananFailing to plan is Planning to fail |
 |
|
|
Japie52
Starting Member
3 Posts |
Posted - 2007-09-20 : 12:59:55
|
| SELECT PART_MASTER.PartNumber, LOC_MASTER.LocNameFROM PART_MASTER CROSS JOIN LOC_MASTER; |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-20 : 13:06:21
|
| i'm no access expert but does this work:SELECT PART_MASTER.PartNumber, LOC_MASTER.LocNameFROM PART_MASTER, LOC_MASTER;_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
Japie52
Starting Member
3 Posts |
Posted - 2007-09-20 : 14:35:18
|
Yes, indeed. Thanks very muchquote:
Originally posted by spirit1
i'm no access expert but does this work:SELECT PART_MASTER.PartNumber, LOC_MASTER.LocNameFROM PART_MASTER, LOC_MASTER;_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-21 : 01:58:13
|
| Yes. Old join style without WHERE is cross joinMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
CROSS JOIN