Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Microsoft Access Queries and SQL
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access courses - Microsoft Access Queries and SQL
Resolved · Low Priority · Version Standard
Reply Fri 13 Jul 2007, 17:03Delegate Dave said...
Dave has attended:
No courses
Microsoft Access Queries and SQL
I was trying to create a query and I found the view within Ms Access 2003 were you are able to write an sql query. I would really like to know how the sql code so that ms access will extract the fields name, address and phone number from one table and the orders that they have place from another table.
Thanks, this will really help
Dave
For upcoming training course dates see: Pricing & availability
RE: Microsoft Access Queries and SQL
Hi Dave
I am glad you found the SQL features that Microsoft Access 2003 has to offer. The sql you need to write within Microsoft Access 2003 is: select ID1, name, address, phone number, order, ID2 from table 1, table 2
where ID1 = ID2
If you have fields that are named the same in both table you should declare the fields you want as table1.ID1 and table2.ID1 etc.
Hope this helps
David
|