select * from multiple tables????


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: select * from multiple tables????

  1. #1
    Martin S Guest

    select * from multiple tables????


    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

  2. #2
    Raju Banandur Guest

    RE: select * from multiple tables????


    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center