>I have three tables customer, sales, arcsales
>
>I'm trying to get this result
>
>Show all records in the customer table
>+ the corresponding sales volume field if a record exist in sales or arcsales, all in one SQL statement.
>
>
>Thanks in advance
Same way as you would if you are running the query directly to whatever your database is. If the question is if you have the three tables in ADO recordsets and want to run it from them it can't be done AFAIK. What you would do is run it on the backend and put that in an ADO RS. That's what the RDBMS is there for isn't it? ANSI-SQL would be something like:
Select customer.*, Sum(sales.dollars), Sum(arcsales.dollars)
From Customer Left Outer Join Sales On customer.custid = sales.custid
Left Outer Join arcsales On customer.custid=arcsales.custid
Group By customer.custid