PRAKTIKUM BASIS DATA (EVI – 04209027)

SOAL NOMOR 1

Buat query sql yang menampilkan semua query dari A dan B

JAWABAN NOMOR 1

SELECT *

FROM bbc RIGHT JOIN games

ON bbc.region=games.continent

 

SOAL NOMOR 2

Buat query sql yang menampilkan semua query dari A dan B kecuali perpotongannya

JAWABAN NOMOR 2

SELECT *

FROM bbc RIGHT JOIN games

ON bbc.region=games.continent

WHERE

(

bbc.region NOT IN (SELECT bbc.region FROM bbc,games WHERE bbc.region = games.continent)

OR

games.continent NOT IN (SELECT games.continent FROM bbc,games WHERE bbc.region = games.continent)

)

 

 

 

 

Posted in Uncategorized | Leave a comment

Hello world!

Welcome to Web Blog Mahasiswa Universitas Narotama Sites. This is your first post. Edit or delete it, then start blogging!

Posted in Uncategorized | 1 Comment