query explanation

Hi ALL, CAN ANY1 EXPLAIN ME ABOUT THIS QUERY.HOW THIS QUERY IS WORKING.? --create table table1 (firstname varchar(50),   [key] varchar(50))

--create table table2 (firstname varchar(50),   [key Go to the complete details ...