forked from deenjohn/FullStack-Learning-Resources
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDATABASE.SQL
More file actions
81 lines (47 loc) · 899 Bytes
/
DATABASE.SQL
File metadata and controls
81 lines (47 loc) · 899 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
book reference
https://www.amazon.in/Database-Systems-Concepts-Sixth-Silberschatz/dp/0071325220
.................
JOINS
1) LEFT JOIN
USE test //DB
CREATE TABLE RS (
ID int
);
CREATE TABLE LS (
ID int
);
INSERT INTO LS (ID)
VALUES (2);
INSERT INTO RS (ID)
VALUES (1);
SELECT * FROM LS ;
SELECT * FROM RS ;
SELECT * FROM LS
SELECT * FROM RS
SELECT *
from LS
LEFT JOIN RS
ON LS.ID = RS.ID
SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
.................................................
USE test
CREATE TABLE RS (
ID int ,
COL2 VARCHAR(12)
);
CREATE TABLE LS (
ID int ,
COL4 VARCHAR(12)
);
INSERT INTO LS (ID ,COL4)
VALUES (1 ,'AAA');
INSERT INTO RS (ID ,COL2)
VALUES (2 ,'DDD');
SELECT * FROM LS ;
SELECT * FROM RS ;
SELECT *
from LS
LEFT JOIN RS
ON LS.ID = RS.ID