Quote:
|
select * from gzdata, gzdata1 ...
|
When you select from 2 or more table without specifying a join condition, you get the records in one table joined with all records in the other in all combinations. So if 100 recs in each of 2 tables you get 10000 rows.