Create Table Fred
    ( TheID INTEGER
    , TheName VARCHAR(20)
    )
Create Table Jobs
    ( TheID INTEGER
    , TheJob VARCHAR(20)
    )
INSERT INTO Fred VALUES (1, 'Fred')
INSERT INTO Fred VALUES (2, 'Freddy')
INSERT INTO Fred VALUES (3, 'Fredrick')
 
INSERT INTO Jobs VALUES (1, 'Boss')
INSERT INTO Jobs VALUES (4, 'Slave')
SELECT F.TheID, F.TheName, J.TheID, J.TheJob
FROM        Fred F
INNER JOIN  Jobs J On J.TheID = F.TheID
SELECT F.TheID, F.TheName, J.TheID, J.TheJob
FROM        Fred F
RIGHT JOIN  Jobs J On J.TheID = F.TheID
SELECT F.TheID, F.TheName, J.TheID, J.TheJob
FROM        Fred F
LEFT  JOIN  Jobs J On J.TheID = F.TheID
 
 
No comments:
Post a Comment