Hi & Thank you!!! But how do I do if I have Many tables that I want to join. For example. I want to see all companies including companys without email and also including companys without telephonenumber etc. Will I need some sort of nested join-query to do this? if so What how shall I write this? Thanks in advance, Martin :cool:

Thanks for your answer Carlos;) But since I am using an Access database it does not seem to work by using "*" sign. I would be grateful for other suggestions!!! Best regards/ Martin :cool:

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 :cool: