Tasavurlar yaratish Tranzaksiyalarni boshqarish

CREATE VIEW sotish_taxlili AS SELECT Tovarlar.Nomi AS Tovar, Sotish.Soni, Tovarlar.Bahosi AS Narxi, Mijoz.Ismi||‘ .Manzil: ‘||Mijoz.Manzil||‘ . tel. ‘|| Mijoz.Telefon AS Mijoz FROM Sotish, Tovarlar, Mijozlar

• CREATE VIEW sotish_taxlili AS SELECT Tovarlar.Nomi AS Tovar, Sotish.Soni, Tovarlar.Bahosi AS Narxi, Mijoz.Ismi||‘ .Manzil: ‘||Mijoz.Manzil||‘ . tel. ‘|| Mijoz.Telefon AS Mijoz FROM Sotish, Tovarlar, Mijozlar
• WHERE Sotish. ID_mijoz=Mijozlar.ID_mijoz AND Sotish.ID_tovar=Tovarlar.ID_tovar;
• Natijada sotish taxlili nomli virtual jadval yaratiladi. Unga so`rovlar yordamida murojat qilish mumkin:
• Masalan:
• Select * from sotish_taxlili where tovar = ‘Sut’ ;
• Tasavurlar MB jadvallar olib tashlangan kabi olib tashlanadi: Masalan
• DROP VIEW Sotish_taxlili;