31.10.2010

use eticaretDB
go

insert into urunlerTbl
(markaID,uretimYili,isim,stokSayisi,fiyati)
values
(2,2011,'XXXYY',67,150)
go

select m.isim as 'Marka Adi',
u.isim as 'Modeli',
u.fiyati as 'Fiyat'
from urunlerTbl u,markalarTbl m where u.markaID=m.id

___eTicaret SQL___