[Solved] what does this sql query do? SELECT column_1 FROM table_1,table_2;

by


In more layman’s terms, it means that for each record in Table A, you get every record from Table B (all possible combinations).

TableA with 3 records and Table B with 3 records gives 9 total records in the result:

TableA-1/B-1
TableA-1/B-2
TableA-1/B-3
TableA-2/B-1
TableA-2/B-2
TableA-2/B-3
TableA-3/B-1
TableA-3/B-2
TableA-3/B-3

Often used as a basis for Cartesian Queries (which themselves are the means to generate, say, a list of future dates based on a recurrence schedule: give me all possible results for the next 6 months, then restrict that set to those whose factor matches my day of the week)

0

solved what does this sql query do? SELECT column_1 FROM table_1,table_2;