RE: SQL Query Help Please.

2004-10-12 Thread Al Everett
> 2.) Can someone please suggest a good book on SQL syntax "Teach Yourself SQL in 10 Minutes" by Ben Forta. ISBN 0-672-32128-9 ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com [Todays Threads] [This Message] [Subscript

Re: SQL Query Help Please.

2004-10-12 Thread Nomad
Thanks Umer & Others, You guys have been of great help. Will try the query today.. Regards, Mark - Original Message - From: "Umer Farooq" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 11, 2004 8:17 PM Subject: Re: SQL Que

RE: SQL Query Help Please.

2004-10-12 Thread Cornillon, Matthieu (Consultant)
2.) Can someone please suggest a good book on SQL syntax that will clear thing up for me. Other beginner resources: 1) http://www.sqlcourse.com/ 2) http://sqlcourse2.com/ 3) http://www.freeprogrammingresources.com/sql.html   (links to many others) [Todays Threads] [This Message] [Sub

Re: SQL Query Help Please.

2004-10-11 Thread Umer Farooq
Here you.. go.. returns.. orderId, date, customerId, customer name, paymentReceived, amount due (per order)... ,     SELECT orders.orderId, order.orderDate, orders.customerID,    customers.customerName, customerPayment.PaymentReceived    (SELECT sum(unitPrice * quantity)   

Re: SQL Query Help Please.

2004-10-11 Thread Umer Farooq
   4 11/10/20044740 > 400 > Company5  4 11/10/2004  26400 > 400 > Company5  4 11/10/2004544600 > 400 > - Original Message - > From: "Josh" <[EMAIL PROTECTED]> > To: "CF-

Re: SQL Query Help Please.

2004-10-11 Thread Nomad
: "Josh" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 11, 2004 6:07 PM Subject: Re: SQL Query Help Please. > Here's a start, though you'll have to explain your tables and your > calculations further. > > SELECT > c.Cu

Re: SQL Query Help Please.

2004-10-11 Thread Josh
Here's a start, though you'll have to explain your tables and your calculations further. SELECT c.Customername, a.Orderid, a.Orderdate, ( where is this being stored? AmountReceived maybe this could be d.PaymentReceived  AS AmountReceived ? ), ( put your formula for calculating AmountDue her

Re: SQL Query Help Please.

2004-10-11 Thread Umer Farooq
Hi, http://www.techonthenet.com/access/queries/joins1.htm For beginner I would suggest.. SAMS SQL in 21 Days.. and Google.. :-) Nomad wrote: > Hello! > > I am trying to create a join of four tables to get data from a db in the > format I want. > > The Database tables and fields are: > Orders