G
Guest
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 (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.
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
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.
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