We have created two tables and now let’s enter data into them:<\/p>\n
insert into ogrenci(id,adi,soyadi,sinif) values (1,'faruk','erdem','10-A');\r\ninsert into ogrenci(id,adi,soyadi,sinif) values (2,'nalan','erdem','10-A');\r\ninsert into ogrenci(id,adi,soyadi,sinif) values (3,'ayse','sari','11-B');\r\ninsert into ogrenci(id,adi,soyadi,sinif) values (4,'asl\u0131','ar','12-B');\r\ninsert into sinif(ders,sinif) values ('Matematik','10-A');\r\ninsert into sinif(ders,sinif) values ('Fizik','11-B');<\/pre>\n
Assuming you have done everything correctly up to this point, let’s move on to the intersect example.<\/p>\n
The intersect command will return records that are the same in both tables.<\/p>\n
We will be asked for records whose classes have been opened. To do this, we will use the following command.<\/p>\n
select sinif from ogrenci intersect select sinif from sinif;<\/pre>\n
<\/p>\n
As a result of the query, we see that there are 10-A and 11-B. This is because the 10-A and 11-B records are common to both tables.<\/p>\n
As a result of this query, we see that 10-A and 11-B are opened, but the class is not opened even though there is a student waiting to enroll in the 12-B class.<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/01\/img_65932642ec67c.png\")
<\/p>\n![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/intersect2.png\")
<\/p>\n![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/intersect3.png\")
<\/p>\n