• Home
  • Blog
  • About
  • Contact

"platform to share ideas and knowledge about SQL"

JOIN in SQL – Inner Join and Outer Join

SQL Basic Raj Leave a Comment

JOIN is one of the fundamental units of relational database system. Generally JOIN is used to combine related data from many tables to produce result. There are different types of…

Read more »

Recent Posts

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

Categories

  • Data warehouse
  • How to topics
  • Index
  • Partition
  • Performance & Troubleshooting
  • quick bite
  • SQL Basic
  • SSIS

Topics

Compression Data warehouse Date DBCC DMV Error Handling Fact How to topics Identity Index JOIN OUTPUT Query Performance ROLLBACK SELECT SQL Server misc SSIS Table Table Partition Table Value Transaction TRUNCATE

Contact Us

  • Email
    contact@intellectSQL.com

Recent Posts

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

Site Links

  • About
  • Blog
  • Contact
  • Home
  • Privacy Policy

Contact

  • Email
    contact@intellectSQL.com

RSS blog – feed

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

About intellectSQL

intellectSQL is a platform to share ideas and knowledge about SQL, Data engineering, warehouse and more …

© 2025 intellectSQL
  • Home
  • Blog
  • About
  • Contact