avoid cross join. try to use inner join or outer join if possible use primary/foreign key relation between two tables and do join with that particular column..
something like below
SELECT Table1.column1 , Table2.column2
FROM Table1 INNER JOIN
Table2 ON Table1 .column1= Table2.column2