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 (orderid,customerid,Orderdate)
OrderDetails(Orderid,UnitPrice,productid,quantity)
Customer(Customerid, customername, address)
CustomerPayments(orderid,PaymentReceived)
My purpose is to track the account status of the customer for each order
they have placed.
The desired format of result obtained from the query is like this:
Customername, Orderid, Orderdate,AmountReceived, AmountDue(this is a
calculated column).
I am using Access 2000 with CFusion.
1.)Can someone help me with the SQL syntax please. I have tried several
permutations and combinations of sql (to the best of my knowledge) but
without success.
2.) Can someone please suggest a good book on SQL syntax that will clear
thing up for me.
Many Thanks in Advance,
Mark Taylor
Admin
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
