Horje
joint query Code Example
joint query 
SELECT table1.column1,table1.column2,table2.column1,....
FROM table1 
LEFT JOIN table2
ON table1.matching_column = table2.matching_column;


table1: First table.
table2: Second table
matching_column: Column common to both the tables.
joint query 
SELECT table1.column1,table1.column2,table2.column1,....
FROM table1 
INNER JOIN table2
ON table1.matching_column = table2.matching_column;


table1: First table.
table2: Second table
matching_column: Column common to both the tables.
Source: www.geeksforgeeks.org
joint query 
SELECT StudentCourse.COURSE_ID, Student.NAME, Student.AGE FROM Student
INNER JOIN StudentCourse
ON Student.ROLL_NO = StudentCourse.ROLL_NO;
Source: www.geeksforgeeks.org



Sql

Related
eloquent to sql with bindings Code Example eloquent to sql with bindings Code Example
update having mysql Code Example update having mysql Code Example
Postpresql relation not found Code Example Postpresql relation not found Code Example
how to tun mysql on ubunto Code Example how to tun mysql on ubunto Code Example
how to change oracle sid name in 19c database Code Example how to change oracle sid name in 19c database Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje