http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/9666.aspxWed, 23 Jul 2014 11:58:07 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9666maneaflorin@hotmail.com0http://sqlserver.ro/forums/thread/9666.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=9666Salut,<br><br>Am o tabela de analize medicale (id, cod, denumire), una de parametri analize (id, id_analiza, denumire) si una de rezultate (id,id_param, rezultat, codpacient).<br><br>Cum fac sa obtin toate analizele care nu au niciun parametru necompletat?<br><br>Daca zic <br><br><i>Select A.analiza, R.codpacient from Rezultate R<br>Inner Join Parametri P On P.id=R.id_param<br>Inner Join Analize A On P.id_analiza=A.id<br>where R.rezultat is null</i><br><br>obtin toate valorile necompletate. O analiza poate avea mai multi parametri si ma intereseaza doar analizele care nu au niciun parametru completat.<br><br>Exemplu:<br><b><br>Analiza&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parametru&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rezultat</b><br>Glucoza &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; /2h&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; null&nbsp; <br>Examen de urina&nbsp;&nbsp;&nbsp;&nbsp; epitelii&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; null<br>Examen de urina&nbsp;&nbsp;&nbsp;&nbsp; celule&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; frecvente<br><br>Ma intereseaza sa obtin doar Glucoza, nu si Examenul de urina.<br><br><br>Se poate face din Join sau aplic un cursor si parcurg toate inregistrarile?<br>Multumesc,<br>Florin<br>