[Zope-dev] SQL Method Question

Tue, 14 Nov 2000 13:59:58 -0600

This is a multi-part message in MIME format.

------=_NextPart_000_0030_01C04E43.2CDA8E30
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I need to do a SQL Outer Join information from three different tables =
and display the results on a page and I can't figure out how to write =
the query in a single SQL method. I can't create a temporary table due =
to tight disk space. Any suggestions?

Thanks
Steven Grimes
Database Engineer
sgrimes@atinucleus.com

Accelerated Technology, Inc.
Mobile, AL
www.atinucleus.com

------------------------------------------------------------
   "Nucleus.  All You NEED in an RTOS.  Royalty Free."
------------------------------------------------------------

------=_NextPart_000_0030_01C04E43.2CDA8E30
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>I need to&nbsp;do a SQL Outer Join information from three different =
tables=20
and display the results on a page and I can't figure out how to write =
the query=20
in a single SQL method. I can't create a temporary table due to tight =
disk=20
space. Any suggestions?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks<BR>Steven Grimes<BR>Database Engineer<BR><A=20
href=3D"mailto:sgrimes@atinucleus.com">sgrimes@atinucleus.com</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>Accelerated Technology, Inc.</DIV>
<DIV>Mobile, AL<BR><A=20
href=3D"http://www.atinucleus.com">www.atinucleus.com</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>------------------------------------------------------------<BR>&nbs=
p;&nbsp;=20
"Nucleus.&nbsp; All You NEED in an RTOS.&nbsp; Royalty=20
Free."<BR>------------------------------------------------------------</D=
IV></BODY></HTML>

------=_NextPart_000_0030_01C04E43.2CDA8E30--