How to use cross join in access?

by

I’m not sure about what do want to accomplish, but the syntax for a full cartesian product(cross join) is select * from table1, table2

If you don’t want to cross everything but only some columns, something like 

SELECT *
FROM (select id from details) b, (select detail from details) c
;

should work:

id  detail
1   name
2   name
3   name
4   name
5   name
1   email
2   email
....

Hope this helps.

More Related Contents:

  1. Combine values from related rows into a single concatenated string value
  2. Bang Notation and Dot Notation in VBA and MS-Access
  3. “General error Unable to open registry key Temporary (volatile) …” from Access ODBC
  4. Is there a simple way of populating dropdown in this Access Database schema?
  5. How do I make a stored procedure in MS Access?
  6. How can I get table names from an MS Access Database?
  7. Is there any way to create multiple insert statements in a ms-access query?
  8. Running Microsoft Access as a Scheduled Task
  9. How to diagnose MS access crashes
  10. “Operation must use an updateable query” error in MS Access
  11. VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
  12. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  13. MS Access trigger?
  14. MS Access LIMIT X, Y
  15. Prevent enabling of shift bypass – Access 2010
  16. Access query producing results like ROW_NUMBER() in T-SQL
  17. Is MS Access (JET) suitable for multiuser access?
  18. Save password for ODBC connection to MS SQL server from MS Access 2007
  19. ConcatRelated() in Access, using two keys
  20. Concatenating multiple rows into single line in MS Access [duplicate]
  21. How to write Case Sensitive Query for MS Access?
  22. Access VBA: Find max number in column and add 1
  23. ConcatRelated function in a query
  24. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  25. Create sequential ID value based on the year that a record is added
  26. How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?
  27. Using a centralized VBA module in multiple Access databases
  28. How to execute a query in ms-access in VBA code?
  29. How to add a menu item to the default right click context menu
  30. Force all users to disconnect from 2010 Access backend database

Leave a Comment