/* 25 -cross_join */ -- first value of first table pair with all the value of second table, same process start with second value of first table ans so on -- create table"city" and insert records -- CREATE TABLE city( cid INT NOT NULL AUTO_INCREMENT, cityname VARCHAR(50) NOT NULL, PRIMARY KEY (cid) ); -- INSERT INTO city(cityname) -- VALUES('Agra'), ('Delhi'), ('Bhopal'), ('Jaipur'), ('Noida'); -- create table "tOne" and insert records -- CREATE TABLE tOne( id INT NOT NULL, name VARCHAR(50) NOT NULL, percentage INT NOT NULL, age INT NOT NULL, gender VARCHAR(1) NOT NULL, city INT NOT NULL, PRIMARY KEY (id), FOREIGN KEY (city) REFERENCES City (cid) ); -- INSERT INTO tOne(id,name,percentage,age,gender,city) -- VALUES (1,"Ram Kumar","45","13","M",1), (2,"Sarita Kumari","56","21","F",2), (3,"Salman Khan","62","20","M",1), (4,"Juhi Chawla","47","18","F",3), (5,"Anil Kapoor","74","22","M",1), (6,"John Abraham","64","21","M",2), (7,"Shahid Kapoor","52","20","M",1); --CROSS JOIN SELECT p.id,p.name,c.cityname FROM tOne p CROSS JOIN city c; SELECT p.id,p.name AS Name,c.cityname AS City FROM tOne p CROSS JOIN city c; SELECT p.id,p.name AS Name,c.cityname AS City FROM tOne p , city c;