FROM KargoFirmalari INNER JOIN Siparisler
ON KargoFirmalari.KFirmaID=Siparisler.MusteriID
*******************************************************
SELECT Siparisler.SiparisID,KargoFirmalari.KFirmaAdi
FROM Siparisler INNER JOIN KargoFirmalari,Musteriler
ON KargoFirmalari.KFirmaID=Siparisler.MusteriID
**********************************************************
SELECT Siparisler.SiparisID,Urunler.UrunAdi,Urunler.Fiyat
FROM Siparisler INNER JOIN Urunler
ON Siparisler.SiparisID=Urunler.UrunID
Where Siparisler.SiparisID=36
**********************************************************
SELECT Musteriler.MusteriAdi,Siparisler.MusteriID,Urunler.UrunAdi,Urunler.Fiyat
FROM Siparisler INNER JOIN SiparisDetaylari
ON SiparisDetaylari.SiparisID=Siparisler.SiparisID
INNER JOIN Urunler
ON SiparisDetaylari.UrunID=Urunler.UrunID
INNER JOIN Musteriler
ON
Musteriler.MusteriID=Siparisler.MusteriID
Where Siparisler.MusteriID=36
*************************************************************
SELECT Musteriler.MusteriAdi,Siparisler.SiparisTarihi,Musteriler.Sehir,KargoFirmalari.KFirmaAdi
From Musteriler
INNER JOIN Siparisler
ON Musteriler.MusteriID=Siparisler.MusteriID
Inner JOIN KargoFirmalari
ON KargoFirmalari.KFirmaID=Siparisler.KargoFirmaID
Where Musteriler.Sehir="Ankara"
