{"id":53477,"date":"2019-04-10T11:30:08","date_gmt":"2019-04-10T06:00:08","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=53477"},"modified":"2021-12-05T21:37:01","modified_gmt":"2021-12-05T16:07:01","slug":"create-joins-in-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/","title":{"rendered":"Joins in SAP HANA – Create Standard Database & Specific Joins in 7 Mins"},"content":{"rendered":"

Earlier, we learned to create\u00a0tables\u00a0in SAP HANA<\/strong>, now, we will learn the different types of joins in SAP HANA.<\/p>\n

Data tables are a crucial element in SAP HANA modeling and data designing. As we know, SAP HANA hosts many kinds of data sources and allows you to combine records for data modeling from multiple sources of data.<\/p>\n

If we fetch data from different tables or have more than one table in an information model or view, we will need to join these tables.<\/p>\n

In this tutorial, we will start with understanding what are joins, their significance in SAP HANA and then learn the types of joins and script used to create them in SAP HANA.<\/p>\n

What are Joins in SAP HANA?<\/h3>\n

Joins in SAP HANA are used for joining two or more tables having relevant data or records that creates a logical association between the tables.<\/p>\n

The joins are very important to bind the modeling object in a logical framework because these modeling objects are used for reporting and analytical purposes later.<\/p>\n

And, if tables in SAP HANA\u00a0<\/strong>are not joined with an appropriate join type, proper associations will not be formed, and the report analysis will be flawed.<\/p>\n

Types of SAP HANA Joins<\/h3>\n

SAP HANA supports a number of ways to join different data tables together. Before we start to learn the types of joins and how they work in SAP HANA, let us understand the concept of tables.<\/p>\n

Whenever we will talk about a join clause, we presume that the join is applied between two tables. We refer to the two tables as a left table and a right table. The two tables which we will\u00a0use for explanatory purposes are given below:<\/p>\n

Table 1: Customer_Info<\/strong><\/p>\n\n\n\n\n\n\n\n
\n

Customer_ID<\/strong><\/p>\n<\/td>\n

Customer_Name<\/strong><\/td>\n<\/tr>\n
CT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\n<\/tr>\n
CT2<\/span><\/td>\nSameer Khanna<\/span><\/td>\n<\/tr>\n
CT3<\/span><\/td>\n\n

Neeti Rana<\/span><\/p>\n<\/td>\n<\/tr>\n

CT4<\/span><\/td>\n\n

Nimish Kapoor<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Table 2: Order_Details<\/strong><\/p>\n\n\n\n\n\n\n\n\n
Order_ID<\/strong><\/td>\nCustomer_ID<\/strong><\/td>\nProduct_Name<\/strong><\/td>\nTotal_Units<\/strong><\/td>\n<\/tr>\n
\n

1101<\/span><\/p>\n<\/td>\n

CT1<\/span><\/td>\niPad<\/span><\/td>\n300<\/span><\/td>\n<\/tr>\n
\n

1102<\/span><\/p>\n<\/td>\n

CT1<\/span><\/td>\nMacBook<\/span><\/td>\n200<\/span><\/td>\n<\/tr>\n
1103<\/span><\/td>\nCT2<\/span><\/td>\nFridge<\/span><\/td>\n\n

500<\/span><\/p>\n<\/td>\n<\/tr>\n

1104<\/span><\/td>\nCT3<\/span><\/td>\nLED TV<\/span><\/td>\n\n

650<\/span><\/p>\n<\/td>\n<\/tr>\n

1105<\/span><\/td>\nCT5<\/span><\/td>\nCamera<\/span><\/td>\n\n

800<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

You may refer to the SQL script given below to create your own table in SAP HANA. We are providing the script to create the two tables mentioned above. Here the name of our schema is SALES_2018. You can insert the name of your own schema<\/strong> under which you are creating the table.<\/p>\n

Script: <\/strong><\/p>\n

CREATE COLUMN TABLE SALES_2018.\r\n\"CUSTOMER_INFO\" ( \r\n\"Customer_ID\" nvarchar(10) primary key, \r\n\"Customer_Name\" nvarchar(50) \r\n); \r\nINSERT INTO SALES_2018.\"CUSTOMER_INFO\" VALUES ('CT1', 'Rajesh Sharma'); \r\nINSERT INTO SALES_2018.\"CUSTOMER_INFO\" VALUES ('CT2', 'Sameer Khanna'); \r\nINSERT INTO SALES_2018.\"CUSTOMER_INFO\" VALUES ('CT3', 'Neeti Rana'); \r\nINSERT INTO SALES_2018.\"CUSTOMER_INFO\" VALUES ('CT4', 'Nimish Kapoor'); \r\n<\/pre>\n
CREATE COLUMN TABLE SALES_2018.\"ORDER_DETAILS\" ( \r\n\"Order_ID\" integer primary key, \r\n\"Customer_ID\" nvarchar(10), \r\n\"Product_Name\" nvarchar(20), \r\n\"Total_Units\" integer \r\n); \r\nINSERT INTO SALES_2018.\"ORDER_DETAILS\" VALUES (1101, 'CT1','iPad',300); \r\nINSERT INTO SALES_2018.\"ORDER_DETAILS\" VALUES (1102, 'CT1','MacBook',200); \r\nINSERT INTO SALES_2018.\"ORDER_DETAILS\" VALUES (1103, 'CT2','Fridge',500); \r\nINSERT INTO SALES_2018.\"ORDER_DETAILS\" VALUES (1104, 'CT3','LED TV',650); \r\nINSERT INTO SALES_2018.\"ORDER_DETAILS\" VALUES (1105, 'CT5','Camera',800);<\/pre>\n
1. Standard Database Joins<\/h4>\n
i. Inner Join<\/h5>\n
The inner joins in SAP HANA join\u00a0the left and right tables with only matching records. That is, only that part is displayed in both tables that coincide. Let us see how inner join will work with the two tables we created.<\/p>\n\n\n\n\n\n\n\n
\n
Order_ID<\/strong><\/p>\n<\/td>\n
Customer_ID<\/strong><\/td>\nCustomer_Name<\/strong><\/td>\nProduct_Name<\/strong><\/td>\nTotal_Units<\/strong><\/td>\n<\/tr>\n
\n
1101<\/span><\/p>\n<\/td>\n
CT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\niPad<\/span><\/td>\n300<\/span><\/td>\n<\/tr>\n
\n
1102<\/span><\/p>\n<\/td>\n
CT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\nMacBook<\/span><\/td>\n\n
200<\/span><\/p>\n<\/td>\n<\/tr>\n
1103<\/span><\/td>\nCT2<\/span><\/td>\nSameer Khanna<\/span><\/td>\nFridge<\/span><\/td>\n\n
500<\/span><\/p>\n<\/td>\n<\/tr>\n
1104<\/span><\/td>\nCT3<\/span><\/td>\nNeeti Rana<\/span><\/td>\nLED TV<\/span><\/td>\n\n
650<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
As you can see, data related to only the customers CT1, CT2, and CT3 were taken in the final table because only these are common between the left and right table. Inner joins are very useful while creating information models as you can use it to join tables in Attribute Views<\/strong>.<\/p>\n
You can also use it to join the master data tables with fact tables of Analytic Views when referential integrity of records is not assured.<\/p>\n
\"Joins<\/a><\/p>\n
The script to create inner join is shown below (here T1 is table 1 and T2 is table 2):<\/p>\n
SELECT T2.\"Order_ID\", T1.\"Customer_ID\", T1.\"Customer_Name\", T2.\"Product_Name\", T2.\"Total_Units\" \r\nfrom \"CUSTOMER_INFO\" AS T1 \r\nINNER JOIN \r\n\"ORDER_DETAILS\" AS T2 \r\nON T1.\"Customer_ID\" = T2.\"Customer_ID\";<\/pre>\n
ii. Left Outer Join<\/h5>\n
The left outer joins combine the entire left table with only the matching records from the right table. Sometimes, if the engine can\u2019t find any records matching for the left columns in the right table then it returns NULL at those places.<\/p>\n
\"Joins<\/a><\/p>\n
In our case, all the rows and columns from the left table CUSTOMER_INFO will be fetched and joined with only the matching records in the right table ORDER_DETAILS.<\/p>\n\n\n\n\n\n\n\n\n
Order_ID<\/strong><\/td>\nCustomer_ID<\/strong><\/td>\nCustomer_Name<\/strong><\/td>\nProduct_Name<\/strong><\/td>\n\n
Total_Units<\/strong><\/p>\n<\/td>\n<\/tr>\n
1101<\/span><\/td>\nCT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\niPad<\/span><\/td>\n300<\/span><\/td>\n<\/tr>\n
\n
1102<\/span><\/p>\n<\/td>\n
CT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\nMacBook<\/span><\/td>\n200<\/span><\/td>\n<\/tr>\n
1103<\/span><\/td>\nCT2<\/span><\/td>\nSameer Khanna<\/span><\/td>\nFridge<\/span><\/td>\n\n
500<\/span><\/p>\n<\/td>\n<\/tr>\n
1104<\/span><\/td>\nCT3<\/span><\/td>\nNeeti Rana<\/span><\/td>\nLED TV<\/span><\/td>\n\n
650<\/span><\/p>\n<\/td>\n<\/tr>\n
NULL<\/span><\/td>\nCT<\/span><\/td>\nNimish Kapoor<\/span><\/td>\nNULL<\/span><\/td>\n\n
NULL<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
The script to create left outer join is shown below (here T1 is table 1 and T2 is table 2):<\/p>\n
SELECT T2.\"Order_ID\", T1.\"Customer_ID\", T1.\"Customer_Name\", T2.\"Product_Name\", T2.\"Total_Units\" \r\nfrom \"CUSTOMER_INFO\" AS T1 \r\nLEFT OUTER JOIN \r\n\"ORDER_DETAILS\" AS T2 \r\nON T1.\"Customer_ID\" = T2.\"Customer_ID\";<\/pre>\n
 <\/p>\n
iii. Right Outer Join<\/h5>\n
The right outer joins in SAP HANA combines the entire right table with the matching contents in the left table. The right outer join is very rarely used in real scenarios. It returns NULL in place of values which do not find an association with the records in the right table.<\/p>\n
\"Joins<\/a><\/p>\n
In our case, all the records from the right table ORDER_DETAILS will be fetched and only the matching or associated records from the left table CUSTOMER_INFO will be taken. The final table is shown below.<\/p>\n\n\n\n\n\n\n\n\n
Order_ID<\/strong><\/td>\nCustomer_ID<\/strong><\/td>\nCustomer_Name<\/strong><\/td>\nProduct_Name<\/strong><\/td>\n\n
Total_Units<\/strong><\/p>\n<\/td>\n<\/tr>\n
1101<\/span><\/td>\nCT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\niPad<\/span><\/td>\n300<\/span><\/td>\n<\/tr>\n
\n
1102<\/span><\/p>\n<\/td>\n
CT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\nMacBook<\/span><\/td>\n200<\/span><\/td>\n<\/tr>\n
\n
1103<\/span><\/p>\n<\/td>\n
CT2<\/span><\/td>\nSameer Khanna<\/span><\/td>\nFridge<\/span><\/td>\n\n
500<\/span><\/p>\n<\/td>\n<\/tr>\n
1104<\/span><\/td>\nCT3<\/span><\/td>\nNeeti Rana<\/span><\/td>\nLED TV<\/span><\/td>\n\n
650<\/span><\/p>\n<\/td>\n<\/tr>\n
1105<\/span><\/td>\nCT5<\/span><\/td>\nNULL<\/span><\/td>\nCamera<\/span><\/td>\n\n
800<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
The script to create a right outer join is shown below (here T1 is table 1 and T2 is table 2):<\/p>\n
SELECT T2.\"Order_ID\", T1.\"Customer_ID\", T1.\"Customer_Name\", T2.\"Product_Name\", T2.\"Total_Units\" \r\nfrom \"CUSTOMER_INFO\" AS T1 \r\nRIGHT OUTER JOIN \r\n\"ORDER_DETAILS\" AS T2 \r\nON T1.\"Customer_ID\" = T2.\"Customer_ID\";\r\n<\/pre>\n
iv. Full Outer Join\/Union<\/h5>\n
A full outer joins in SAP HANA combines all the records from both left and right tables irrespective of the matching conditions. The cells which do not find any association with the other table are left NULL. It is also known as a union.<\/p>\n
\"Full<\/a><\/p>\n
The tables CUSTOMER_INFO and ORDER_DETAILS will have all their records in the final table as shown below.<\/p>\n\n\n\n\n\n\n\n\n\n
\n
Order_ID<\/strong><\/p>\n<\/td>\n
Customer_ID<\/strong><\/td>\nCustomer_Name<\/strong><\/td>\nProduct_Name<\/strong><\/td>\nTotal_Units<\/strong><\/td>\n<\/tr>\n
\n
1101<\/span><\/p>\n<\/td>\n
CT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\niPad<\/span><\/td>\n300<\/span><\/td>\n<\/tr>\n
\n
1102<\/span><\/p>\n<\/td>\n
CT1<\/span><\/td>\nRajesh Sharma<\/span><\/td>\nMacBook<\/span><\/td>\n200<\/span><\/td>\n<\/tr>\n
\n
1103<\/span><\/p>\n<\/td>\n
CT2<\/span><\/td>\nSameer Khanna<\/span><\/td>\nFridge<\/span><\/td>\n500<\/span><\/td>\n<\/tr>\n
1104<\/span><\/td>\nCT3<\/span><\/td>\nNeeti Rana<\/span><\/td>\nLED TV<\/span><\/td>\n\n
650<\/span><\/p>\n<\/td>\n<\/tr>\n
NULL<\/span><\/td>\nCT4<\/span><\/td>\nNimish Kapoor<\/span><\/td>\nNULL<\/span><\/td>\n\n
NULL<\/span><\/p>\n<\/td>\n<\/tr>\n
1105<\/span><\/td>\nCT5<\/span><\/td>\nNULL<\/span><\/td>\nCamera<\/span><\/td>\n\n
800<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
The script to create full outer join is shown below (here T1 is table 1 and T2 is table 2):<\/p>\n
SELECT T2.\"Order_ID\", T1.\"Customer_ID\", T1.\"Customer_Name\", T2.\"Product_Name\", T2.\"Total_Units\" \r\nfrom \"CUSTOMER_INFO\" AS T1 \r\nFULL OUTER JOIN \r\n\"ORDER_DETAILS\" AS T2 \r\nON T1.\"Customer_ID\" = T2.\"Customer_ID\";<\/pre>\n
2. Specific Joins<\/h4>\n
These join types are SAP HANA SQL script-specific joins:<\/p>\n
i. Referential Join<\/h5>\n
Referential join is the default join type in SAP HANA modeling. A referential join is similar to an inner join. The only difference between the two is referential integrity must be ensured in the case of referential join otherwise it cannot be formed.<\/p>\n
So, before we move forward with understanding referential integrity. Let us learn the basic concept of a referential join. It is formed between a fact table (transaction data or Analytic View<\/strong>) and a master data table( Attribute View<\/strong>).<\/p>\n
Every master data table has a primary key column which acts as a foreign key in the fact table.<\/p>\n
Referential joins in SAP HANA are used whenever there is a primary key and foreign key association between two tables. And, referential integrity is when for every value in the foreign key column, there is a reference value in the primary key column of the master data table.<\/p>\n
From a performance point of view, referential joins are better than inner joins. Referential joins are recommended for star schemas as long as referential integrity is maintained.<\/p>\n\n\n\n\n\n\n\n
\n
Customer_ID<\/strong><\/p>\n<\/td>\n
Customer_Name<\/strong><\/td>\nCity_Code<\/strong><\/td>\nRegion<\/strong><\/td>\n<\/tr>\n
\n
CT1<\/span><\/p>\n<\/td>\n
Rajesh Sharma<\/span><\/td>\nMUM<\/span><\/td>\nEast<\/span><\/td>\n<\/tr>\n
CT2<\/span><\/td>\nSameer Khanna<\/span><\/td>\nIDR<\/span><\/td>\n\n
Central<\/span><\/p>\n<\/td>\n<\/tr>\n
CT3<\/span><\/td>\nNeeti Rana<\/span><\/td>\nHYD<\/span><\/td>\n\n
South<\/span><\/p>\n<\/td>\n<\/tr>\n
CT4<\/span><\/td>\nNimish Kapoor<\/span><\/td>\nCHN<\/span><\/td>\n\n
South <\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\"Referential<\/a><\/p>\n\n\n\n\n\n\n\n\n
Order_No.<\/strong><\/td>\nCustomer_ID<\/strong><\/td>\nProduct_Name<\/strong><\/td>\nTotal_Units<\/strong><\/td>\nPRICE<\/strong><\/td>\n<\/tr>\n
\n
1101987<\/span><\/p>\n<\/td>\n
CT1<\/span><\/td>\niPad<\/span><\/td>\n300<\/span><\/td>\n40,000<\/span><\/td>\n<\/tr>\n
\n
1102568<\/span><\/p>\n<\/td>\n
CT1<\/span><\/td>\nMacBook<\/span><\/td>\n200<\/span><\/td>\n80,500<\/span><\/td>\n<\/tr>\n
1103282<\/span><\/td>\nCT2<\/span><\/td>\nFridge<\/span><\/td>\n500<\/span><\/td>\n\n
 95,000<\/span><\/p>\n<\/td>\n<\/tr>\n
1104229<\/span><\/td>\nCT3<\/span><\/td>\nLED TV<\/span><\/td>\n650<\/span><\/td>\n\n
1,20,000<\/span><\/p>\n<\/td>\n<\/tr>\n
1105554<\/span><\/td>\nCT4<\/span><\/td>\nCamera<\/span><\/td>\n800<\/span><\/td>\n\n
28,000<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
ii. Text Join<\/h5>\n
Text joins in SAP HANA provides a description of text records in the language specific to the user. If user A has selected the language as German, then all the details regarding the table and columns will be displayed to the user in German.<\/p>\n
We use text joins to join a text table with a master data table. The text table must have a primary key column linked to the other data table and a language key column which contains user language preferences. Text joins are also used with SAP tables having SPRAS session language columns.<\/p>\n
Summary<\/h3>\n
This concludes our tutorial on Joins in SAP HANA. We hope now you understand what join types to use in which condition during information modeling.<\/p>\n
If you have any queries and suggestions related to SAP HANA Joins Tutorial, drop your comments in the comment box below.<\/p>\n","protected":false},"excerpt":{"rendered":"
Earlier, we learned to create\u00a0tables\u00a0in SAP HANA, now, we will learn the different types of joins in SAP HANA. Data tables are a crucial element in SAP HANA modeling and data designing. As we...<\/p>\n","protected":false},"author":6,"featured_media":53748,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19411,19414,19413,19412],"class_list":["post-53477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-joins-in-sap-hana","tag-specific-joins-in-sap-hana","tag-standard-database-joins","tag-types-of-joins-in-sap-hana"],"yoast_head":"\nJoins in SAP HANA - Create Standard Database & Specific Joins in 7 Mins - DataFlair<\/title>\n<meta name=\"description\" content=\"SAP HANA Joins Tutorial covers the explanation of joins in SAP HANA, types of join; Standard Database Joins and Specfic Joins. Learn to create them now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Joins in SAP HANA - Create Standard Database & Specific Joins in 7 Mins - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SAP HANA Joins Tutorial covers the explanation of joins in SAP HANA, types of join; Standard Database Joins and Specfic Joins. Learn to create them now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-10T06:00:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-05T16:07:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Joins-in-SAP-HANA-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Joins in SAP HANA - Create Standard Database & Specific Joins in 7 Mins - DataFlair","description":"SAP HANA Joins Tutorial covers the explanation of joins in SAP HANA, types of join; Standard Database Joins and Specfic Joins. Learn to create them now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"Joins in SAP HANA - Create Standard Database & Specific Joins in 7 Mins - DataFlair","og_description":"SAP HANA Joins Tutorial covers the explanation of joins in SAP HANA, types of join; Standard Database Joins and Specfic Joins. Learn to create them now!","og_url":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-04-10T06:00:08+00:00","article_modified_time":"2021-12-05T16:07:01+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Joins-in-SAP-HANA-1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Joins in SAP HANA – Create Standard Database & Specific Joins in 7 Mins","datePublished":"2019-04-10T06:00:08+00:00","dateModified":"2021-12-05T16:07:01+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/"},"wordCount":1337,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Joins-in-SAP-HANA-1.jpg","keywords":["Joins in SAP HANA","Specific Joins in SAP HANA","Standard Database Joins","Types of Joins in SAP HANA"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/","name":"Joins in SAP HANA - Create Standard Database & Specific Joins in 7 Mins - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Joins-in-SAP-HANA-1.jpg","datePublished":"2019-04-10T06:00:08+00:00","dateModified":"2021-12-05T16:07:01+00:00","description":"SAP HANA Joins Tutorial covers the explanation of joins in SAP HANA, types of join; Standard Database Joins and Specfic Joins. Learn to create them now!","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Joins-in-SAP-HANA-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Joins-in-SAP-HANA-1.jpg","width":1200,"height":628,"caption":"Joins in SAP HANA"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/create-joins-in-sap-hana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"Joins in SAP HANA – Create Standard Database & Specific Joins in 7 Mins"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=53477"}],"version-history":[{"count":23,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53477\/revisions"}],"predecessor-version":[{"id":105070,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53477\/revisions\/105070"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/53748"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=53477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=53477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=53477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}