Select D.orderid from
Header H , Detail D
Where H.orderID = D.Orderid
And D.OrdDate between '6/1/04' and '1/1/05'
And Qty % 50 =0
% is modulo which gives remainder after division
Stephen F Zelonis
Information Services
[EMAIL PROTECTED]
(610) 701-3025
If you feel a tingle, that's probably your DNA changing as you read
this...
-----Original Message-----
From: j shesek [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 4:06 PM
To: [email protected]
Subject: [asp] Pulling info from Multiple tables
Hello,
I have to create a report that pulls info from 2 tables with in a date
range. Data is coming out of an Orders table and an Orders Details
table.
The report pulls info based on a date range and only if the client
bought multiples of 50.
Would you guys have an idea on how the sql statement would go?
jess
[Non-text portions of this message have been removed]
ASP Resources www.asp-dev.com
============================================================
Learn over lunch. Get the developerWorks newsletter and
enjoy tools, code, and tutorials, along with your sandwich. XML, Linux,
Web services, Java -- and peanut butter!
http://www.topica.com/partner/AP-1RMZ49/partners/ibm/aff_landing.html
============================================================
Yahoo! Groups Links
ASP Resources www.asp-dev.com
============================================================
Learn over lunch. Get the developerWorks newsletter and
enjoy tools, code, and tutorials, along with your sandwich.
XML, Linux, Web services, Java -- and peanut butter!
http://www.topica.com/partner/AP-1RMZ49/partners/ibm/aff_landing.html
============================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/asp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
