http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/7217.aspxTue, 26 May 2009 14:11:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7217neo0http://sqlserver.ro/forums/thread/7217.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7217<P>am rezolvato cu un left outer join</P> <P>&nbsp;</P> <P>multumesc</P>http://sqlserver.ro/forums/thread/7215.aspxMon, 25 May 2009 16:19:46 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7215neo0http://sqlserver.ro/forums/thread/7215.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7215<P>Salut, am si eu urmatoarea problema:</P> <P>am 2 tabele: tabelul&nbsp;<STRONG>t1</STRONG> cu coloanele <STRONG>q1</STRONG> (vchar(10)) ,<STRONG>q2</STRONG> (vchar(10))&nbsp;&nbsp;si <STRONG>t1_istoric</STRONG> cu coloana <STRONG>c1</STRONG> (vchar(10)), <STRONG>c2</STRONG> (vchar(10)) </P> <P>cum ar arata un script cu care sa inserez toate acele valori din <STRONG>t1</STRONG> intr-o a 3-a tabela (o tabela oarecare : de exemplu tabela <STRONG>q3</STRONG>)&nbsp; doar pentru acele valori care:</P> <P>- sa pot insera din <STRONG>t1</STRONG> in&nbsp; <STRONG>t1_istoric</STRONG>&nbsp;&nbsp; daca <STRONG>t1.q1</STRONG> nu se regaseste in <STRONG>t1_istoric</STRONG> .<STRONG>c1</STRONG></P> <P>-&nbsp;sa nu pot insera din &nbsp;<STRONG>t1</STRONG> in <STRONG>t1_istoric</STRONG> daca in <STRONG>t1_istoric.c2&nbsp;</STRONG>am &nbsp;valorile 8 sau 9 pentru&nbsp;acelasi&nbsp;&nbsp;&nbsp; <STRONG>t1</STRONG> .<STRONG>q1</STRONG>=<STRONG>t1_istoric.c1 </STRONG>(adica t1.q1 sa se poata regasi in tabela din dreapta de maxim 2 ori pentru care sa doar un 8 sau doar un 9 pentru valoarea corespunzatoare din c2)</P> <P>multumesc.</P> <P><STRONG></STRONG>&nbsp;</P> <P>&nbsp;</P>