How to return Data from 4 Different tables in Stored Procedure with out using joins?

For selecting columns without join just do like this.

 Select table1.FieldName,table2.FieldName from table1,table2. 

Or 
if you want to take only common fields from different tables without joins do like this.

 select table1.fieldname, table2.fieldname from table1, table2 where table1.commonfiledname = table2.commonfieldname