# Advance

- [Constraint (cheklov) lar](/database/postgresql/advance/constraint-cheklov-lar.md): Muzaffar Nurillayev
- [Join lar](/database/postgresql/advance/join-lar.md): Muzaffar Nurillayev
- [Cross join](/database/postgresql/advance/join-lar/cross-join.md)
- [Inner join](/database/postgresql/advance/join-lar/inner-join.md): Muzaffar Nurillayev
- [Left join](/database/postgresql/advance/join-lar/left-join.md)
- [Right join](/database/postgresql/advance/join-lar/right-join.md)
- [Full join](/database/postgresql/advance/join-lar/full-join.md)
- [Union](/database/postgresql/advance/union.md): Muzaffar Nurillayev