Skip to content
Episode 9: Joins in DBMS episode artwork

May 19, 2022 2 min

Episode 9: Joins in DBMS

from Be With Trends Hosted by Bhavik

By using joins, we can retrieve data from two or more tables based on logical relationships between the tables. Joins indicate how SQL Server should use data from one table to select the rows in another table. Based on the two conditions such as by specifying the column from each table to be used for the join. And a typical join condition specifies a foreign key from one table and its associated key from the other table. SQL Joins are used to fetch/retrieve data from two or more data tables, based on a join condition. A join condition is a relationship among some columns in the data tables that take part in SQL join. Basically, database tables are related to each other with keys. We use this keys relationship in SQL Joins. Types of SQL Joins In SQL Server we have only three types of joins. Using these joins we fetch the data from multiple tables based on condition. 1. Inner Join 2. Outer Join 3.query Cross Join 4. Self Join

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Episode 9: Joins in DBMS

0:00 2:55

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Be With Trends?

This episode is 2 minutes long.

When was this Be With Trends episode published?

This episode was published on May 19, 2022.

Can I download this Be With Trends episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.