|
 |
sql_language thread: Difficult SQL query
Message #1 by "Imar Spaanjaars" <Imar@S...> on Thu, 25 Apr 2002 20:06:09
|
|
Hi there,
Thanks everyone who replied to me on this post.
With the help of Ken Schaefer this problem has been solved over the
weekend.
Imar
> This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1EF0A.9B5BCA40
Content-Type: text/plain
Could you post your table structure and describe exactly what you want
returned? An example using data might be helpful.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: Imar Spaanjaars [mailto:Imar@S...]
Sent: Friday, 26 April 2002 6:06 AM
To: sql language
Subject: [sql_language] Difficult SQL query
Hi there,
I am having a really hard time getting some correct data from a few not
too difficult tables.
Basically it comes down to this:
Someone at the head quarters should be able to define an OrderDesign,
that can consist of 1 to many OrderDesignDetails. Customers should then
be able to order something from the OrderDesign and order 1 to many
OrderDetails from the OrderDesignDetails.
I got most of the stuff working: people can define an OrderDesign and add
Details to it but I can't seem to get the correct information from the
database the moment a customer wants to order something. I have tried
about a zillion combinations but none of them worked correct so far.
It's quite a difficult situation to explain without a database diagram or
some actual data, so I hope some SQL king is willing to help me.
Please drop me a line (either here or at my e-mail address) if you are
able / willing to help me sorting this darn query out.
Thanks in advance,
Imar
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to
------_=_NextPart_001_01C1EF0A.9B5BCA40
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: [sql_language] Difficult SQL query</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Could you post your table structure and describe =
exactly what you want returned? An example using data might be =
helpful.</FONT></P>
<P><FONT SIZE=3D2>regards</FONT>
<BR><FONT SIZE=3D2>David Cameron</FONT>
<BR><FONT SIZE=3D2>nOw.b2b</FONT>
<BR><FONT SIZE=3D2>dcameron@i...</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Imar Spaanjaars [<A =
HREF=3D"mailto:Imar@S...">mailto:Imar@S...</A>]</FON=
T>
<BR><FONT SIZE=3D2>Sent: Friday, 26 April 2002 6:06 AM</FONT>
<BR><FONT SIZE=3D2>To: sql language</FONT>
<BR><FONT SIZE=3D2>Subject: [sql_language] Difficult SQL query</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi there,</FONT>
</P>
<P><FONT SIZE=3D2>I am having a really hard time getting some correct =
data from a few not </FONT>
<BR><FONT SIZE=3D2>too difficult tables. </FONT>
<BR><FONT SIZE=3D2>Basically it comes down to this:</FONT>
<BR><FONT SIZE=3D2>Someone at the head quarters should be able to =
define an OrderDesign, </FONT>
<BR><FONT SIZE=3D2>that can consist of 1 to many OrderDesignDetails. =
Customers should then </FONT>
<BR><FONT SIZE=3D2>be able to order something from the OrderDesign and =
order 1 to many </FONT>
<BR><FONT SIZE=3D2>OrderDetails from the OrderDesignDetails. </FONT>
</P>
<P><FONT SIZE=3D2>I got most of the stuff working: people can define an =
OrderDesign and add </FONT>
<BR><FONT SIZE=3D2>Details to it but I can't seem to get the correct =
information from the </FONT>
<BR><FONT SIZE=3D2>database the moment a customer wants to order =
something. I have tried </FONT>
<BR><FONT SIZE=3D2>about a zillion combinations but none of them worked =
correct so far.</FONT>
</P>
<P><FONT SIZE=3D2>It's quite a difficult situation to explain without a =
database diagram or </FONT>
<BR><FONT SIZE=3D2>some actual data, so I hope some SQL king is willing =
to help me.</FONT>
</P>
<P><FONT SIZE=3D2>Please drop me a line (either here or at my e-mail =
address) if you are </FONT>
<BR><FONT SIZE=3D2>able / willing to help me sorting this darn query =
out.</FONT>
</P>
<P><FONT SIZE=3D2>Thanks in advance,</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Imar</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>---</FONT>
<BR><FONT SIZE=3D2>Change your mail options at <A =
HREF=3D"http://p2p.wrox.com/manager.asp" =
TARGET=3D"_blank">http://p2p.wrox.com/manager.asp</A> or </FONT>
<BR><FONT SIZE=3D2>to unsubscribe send a blank email to =
</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C1EF0A.9B5BCA40--
|
|
|
View Cart
