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
Mon 16 Jul 2007, 09:46Trainer David said...
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 = ID2If 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
