0

Labaratoriya ishi 2

Mavzu: Joinlardan foydalanish.Inner join,Left join,Right join, va Full join.

Talaba: Nazarov Abduqosim
Guruh: 022-19

“avtosalon” nomli database hosil qilamiz:

create database avtosalon;
Table lar hosil qilamiz. Dbeaver dasturi muhitida:
CREATE TABLE salon_a (
a INT PRIMARY KEY,
car_a VARCHAR (100) NOT NULL
);

CREATE TABLE salon_b (

b INT PRIMARY KEY,
car_b VARCHAR (100) NOT NULL
);
Ushbu “postgresql” kodni ishlatamiz:

Endi qiymatlar kiritamiz:

INSERT INTO salon_a (a, car_a)
VALUES
(1, 'damas'),
(2, 'malibu'),
(3, 'tiko'),
(4, 'captiva');

INSERT INTO salon_b (b, car_b)

VALUES
(1, 'nexia'),
(2, 'damas'),
(3, 'ravon'),
(4, 'tiko');

Qiymatlar joylandi.
Endi ‘inner join’ ni ishlatib ko’rsak:

select a,car_a ,b,car_b from salon_a inner join salon_b on car_a=car_b ;



Left join


Left join




right join
V a right outer join


full outer join

Bunda:

Kabidir. Yani umumiy qismini ko’rsatmaydi.

Full join