Database Querying: Join Types -- Theta Joins (condition other than equality)

Описание к видео Database Querying: Join Types -- Theta Joins (condition other than equality)

In this video we start are discussion of types of Join queries. In particular we look at a Theta Join. First we combine two tables into a Cartesian Product and then we start to select out the rows (records) that satisfy some condition. Here we are looking at a "Theta Join" in which the condition in not equality but an inequality. Our example is to combine a person table where the person has a budget and an item table where the item has a price. And we only keep the rows in which the person can afford the items.

Комментарии

Информация по комментариям в разработке

Похожие видео