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 (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]
