Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

SQL Queries in MS Access

Comment:

Hello, I have two tables, one with only phone numbers and the 2nd has Names, Addresses, and Phone Numbers. I need to run a query to see if any of the phone numbers in Table2 match those in Table1. For some reason my syntax is wrong and it will not work. Does anyone have any example for me? Thanks

Name: Infinite Recursion
Date: June 21, 2003 at 20:23:42 Pacific

Reply:

Angilj, I think the below syntax is right, sorry but don't have the software on this machine to test it. SELECT * FROM TABLE1, TABLE2 WHERE TABLE1.PHONE1 = TABLE2.PHONE2; Infinite Recursion

0

Name: Infinite Recursion
Date: June 21, 2003 at 20:24:49 Pacific

Reply:

That will return all record content for the tuples that match based on the phone number field. Hope it helps. Infinite Recursion

0

Reply:

Angilj, Try this. SELECT table1.Name, table1.Addresses, table1.Phone, table2.Phone FROM table1 INNER JOIN table2 ON table1.Phone = table2.Phone;

0

Website statistics

Special programing???

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi Friends I need a report in MS Access (related Banking System) for any customer. My Fields are 1) Date 2) Debit Amount 3) Credit Amount 4) Balance My problem is this that I could not find the Ba...

Summary: I am building a MS Access form. In one of the fields, I want the user to specify a file on the hard drive, to be used later. How do I set the field up to allow the user to browse through the folders o...

Summary: Hi Friends I need a report in MS Access (related Banking System) for any customer. My Fields are 1) Date 2) Debit Amount 3) Credit Amount 4) Balance My problem is this that I could not find the Bala...