Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Append query

Author  Topic 

nt4vn
Yak Posting Veteran

98 Posts

Posted - 2008-06-30 : 10:40:03
I think I will turn this to Visual basic programming since I could not figure out the way that work on access. Thanks for reviewing my question....

TerryNL
Starting Member

21 Posts

Posted - 2008-07-01 : 08:32:15
In what table is the information about the clients? is that in the second table?
then i am wondering whats in the first table

normally you would do something like this:
select CASE_ID, LAWYER-ID, LASTNAME, FIRSTNAME
from table2 inner join table3 on table2.LAWYER-ID references table3.LAWYERID
Go to Top of Page
   

- Advertisement -