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
…
