MySQL cartesian product between two SELECT statements

by

If you specify your tables with out any JOIN ON clause or equalities/conditionins in the WHERE clause you’ll get the catesian product you’re looking for.

SELECT table1.field1, table2.field2
FROM table1, table2

will give you what you’re asking for. Showing it more explicitly…

SELECT * FROM table1;
+--------+
| field1 |
+--------+
|      1 |
|      2 |
+--------+

SELECT * FROM table2;
+--------+
| field2 |
+--------+
|      3 |
|      4 |
+--------+

SELECT table1.field1, table2.field2 FROM table1, table2;
+--------+--------+
| field1 | field2 |
+--------+--------+
|      1 |      3 |
|      2 |      3 |
|      1 |      4 |
|      2 |      4 |
+--------+--------+

More Related Contents:

  1. How can I select data from different tables?
  2. Combine Multiple child rows into one row MYSQL
  3. What is the default MySQL JOIN behaviour, INNER or OUTER?
  4. left join query keep a column empty
  5. What is better subquery vs literal on IN clause in mysql
  6. SQL query return data from multiple tables
  7. MySQL SELECT only not null values
  8. How to use mysql JOIN without ON condition?
  9. What is MySQL row order for “SELECT * FROM table_name;”?
  10. MySQL SELECT increment counter
  11. When to use STRAIGHT_JOIN with MySQL
  12. mysql query show multiple tables from one ID column
  13. How to find non-existing data from another Table by JOIN?
  14. LEFT JOIN only first row
  15. How does MySQL’s ORDER BY RAND() work?
  16. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  17. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  18. MySQL INSERT INTO … VALUES and SELECT
  19. How to select one row randomly taking into account a weight?
  20. Compare only day and month with date field in mysql
  21. MySQL – SQL_BIG_SELECTS
  22. MySQL INNER JOIN select only one row from second table
  23. MySQL how to join tables on two fields
  24. how to use a like with a join in sql?
  25. Insert data into table with result from another select query
  26. How to use Table output from stored MYSQL Procedure
  27. Join two tables (with a 1-M relationship) where the second table needs to be ‘flattened’ into one row
  28. How to store a one to many relation in MySQL database?
  29. MySQL Select Multiple VALUES
  30. mySQL returns all rows when field=0

Leave a Comment