HI there,
  I am using MS-Access . There in the database , I have three tables.
 First table contains two fields namely customerid , custome_name.
Second table contains again the two fields namely productid and product_name.
Third table contains productid , customerid , address.
Is there any way to calculate the customer name , product name , address with in a single query.
Any help will be appreciated.
Thank You.
Pankaj

Try something like this

Table1: tblCustomer
Table2: tblProduct
Table3: tblDetail


select customer_name as 'Customer Name',product_name as 'Product Name', address as Address
 from tblCustomer a,tblProduct b,tblDetail c where
a.customerid = c.customerid and b.productid = c.productid

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

same as the above

TarDuk - A Memory Beyond The Life.