Praktiskais darbs kursā "Datu bāzes"

insert into simptomi values (3,'sap zobi')

insert into simptomi values (4,'sap galva')
go
SELECT dbo.dakteris.Uzvards, dbo.dakteris.Vards AS Expr1, dbo.vizite.Datums, dbo.pacients.Uzvards AS Expr2, dbo.pacients.Vards
FROM dbo.kabinets INNER JOIN
dbo.dakteris ON dbo.kabinets.kID = dbo.dakteris.kID INNER JOIN
dbo.vizite ON dbo.dakteris.dID = dbo.vizite.dID INNER JOIN
dbo.arstesana ON dbo.vizite.aID = dbo.arstesana.aID INNER JOIN
dbo.pacients ON dbo.vizite.pID = dbo.pacients.pID INNER JOIN
dbo.simptomi ON dbo.vizite.sID = dbo.simptomi.sID INNER JOIN
dbo.zales ON dbo.arstesana.zID = dbo.zales.zID

datu baazes fiziskajaa modelii aareejaas atsleegas pagaidaam netiek lietotas, jo visas datu manipulaacijas tiek veiktas caur kontroleetiem riikiem
…