Select * from Table1,Table2

select * from emp

--9 rows

select * from ebottle

--2 rows

select * from emp,ebottle

--(18 row(s) affected)

--9*2=18 (Cross Join)