InstantForum.NET v4.1.4Релибhttp://relib.com/forums/robot@relib.comFri, 22 Aug 2008 04:17:04 GMT20http://relib.com/forums/Topic899994-8-1.aspx<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><FONT color=#000000><FONT face="Times New Roman"><SPAN lang=EN-US style="mso-ansi-language: EN-US">Left outer join </SPAN>не работает:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="mso-ansi-language: EN-US"><FONT size=3><FONT color=#000000><FONT face="Times New Roman">select parking_no from parkings left outer join<o:p></o:p></FONT></FONT></FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="mso-ansi-language: EN-US"><FONT size=3><FONT color=#000000><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>(select parkig_no, count(*) from PARKIG_OPPERATIONS group by parkig_no)<o:p></o:p></FONT></FONT></FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="mso-ansi-language: EN-US"><FONT size=3><FONT color=#000000><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>as TAB_rez(park, numb1)<o:p></o:p></FONT></FONT></FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="mso-ansi-language: EN-US"><FONT size=3><FONT color=#000000><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>on parking_no = TAB_rez.numb1</FONT></FONT></FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><FONT color=#000000><FONT face="Times New Roman"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language: RU; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: RU; mso-bidi-language: AR-SA">всегда останавливается на втором селекте .</SPAN></FONT></FONT></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><FONT color=#000000><FONT face="Times New Roman"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language: RU; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: RU; mso-bidi-language: AR-SA">Где ошибка ??</SPAN></FONT></FONT></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><FONT color=#000000><FONT face="Times New Roman"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language: RU; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: RU; mso-bidi-language: AR-SA"></SPAN></FONT></FONT></FONT> Mon, 03 Jul 2006 14:58:42 GMTmandarin