select * from multiple tables????

[Martin S]

Hi !!
I am using ASP-script and an access-database. I want to make a select query
that shows all the data in many tables how is it possible to do this?
An example:
I want to see the names of all companys in the company-table and I also want
to see their adresses wich are in the adress-table and I also want to see
their email-adresses wich are in the email-table. But I also want to see
the companys who do not have for example an email-adress. How is it possible
to extract this kind of data?

/Martin S

[Raju Banandur]

here is the answer

select A.companyName,B.CompanyAddress,C.emailAdd
from company A,address B,Email C
where A.compId=B.CompId AND A.CompId=C.CompId



>Hi !!
>I am using ASP-script and an access-database. I want to make a select query
>that shows all the data in many tables how is it possible to do this?
>An example:
>I want to see the names of all companys in the company-table and I also want
>to see their adresses wich are in the adress-table and I also want to see
>their email-adresses wich are in the email-table. But I also want to see
>the companys who do not have for example an email-adress. How is it possible
>to extract this kind of data?
>
>/Martin S

Message sent from http://www.aewnet.com