08/04/2023 5:19 pm
Topic starter
Notifications
Clear all
Students’s Forum
3
Posts
4
Users
1
Likes
409
Views
1
please explain the use of join and its types such as inner and outer join
riyaponraj 08/04/2023 6:05 pm
@sukhmander A join in a relational database is an operation that combines data from two or more tables based on a common column or set of columns. It allows you to retrieve data that is stored in different tables and merge it into a single result set.
2 Answers
0
09/04/2023 10:40 am
A join clause in SQL – corresponding to a join operation in relational algebra – combines columns from one or more tables into a new table. Informally, a join stitches two tables and puts on the same row records with matching fields : INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER and CROSS .
0
09/04/2023 11:11 am
Join is a combination of a Cartesian product followed by a selection process. A Join operation pairs two tuples from different relations, if and only if a given join condition is satisfied.
