Muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti 2 – bosqich dbm002-guruh talabasi Abdimannonov Jahongirning “Ma’lumotlar bazasi” fanidan bajargan 3- mustaqil ishi

Natija:

So`rov: SELECT * FROM ticket t

So`rov: SELECT * FROM ticket t

LEFT JOIN passenger p

ON t.passenger_id=p.id;

Natija:

RIGHT JOIN operatori

• RIGHT JOIN operatori

So`rov: SELECT *FROM ticket t

RIGHT JOIN passenger p

ON t.passenger_id=p.id;

 Natija:

CROSS JOIN operatori

CROSS JOIN operatori

So`rov: SELECT *FROM ticket t

CROSS JOIN passenger p

ON t.passenger_id=p.id;

Natija:

FULL OUTER JOIN operatori:

FULL OUTER JOIN operatori:

So`rov: SELECT *FROM ticket t

FULL OUTER JOIN passenger p

ON t.passenger_id=p.id;

Natija: