SQL joins. Not a complete list, but a great representation of what they actually Типы соединения таблиц в sql