Query to return values

[narendrabr]

Hi,



I have two tables called Email and Code,

I need query to return all emails that code field in code table with code field in email table.

Attached the sample database.

Also please provide the steps to where I should write queries as I am new to access.

Thanks!Access example.accdb

[Abedecain]

First you need to make a relationship between the tables, a one to many from code (as the one) and email (As the many)

Then just use the following SQL on a new query

SELECT Email.Email, Code.Code FROM Code INNER JOIN Email ON Code.Code = Email.Code;

[narendrabr]

Hi,

OK.Why we need to make it as one to many?And how to make it?

Where I should write the query and please give the steps.

Thanks

An

[alansidman]

Look here for a quick overview of queries.

http://www.techonthenet.com/access/queries/index.php