By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,461 Members | 1,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,461 IT Pros & Developers. It's quick & easy.

Linking two fields with different names in one table to another table

P: 1
I have the following tables:

(tlbJudgments) with fields, "Plaintiff" and "Defendant"
(tblProperty) with fields, “Grantor” and “Grantee”
(tblIndividuals) with fields “FirstName”, LastName” “Address” etc

It is possible to link the fields Plaintiff and Defendant to the individual table and if so how? Same goes for the Property table. Any suggested way of dealing with the above would be greatly appreciated.

Thanks in advance.
Mar 23 '15 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,430
Is your question how to join tables in general? In which case, I suggest a SQL tutorial because that is one of the basic functionalities you should learn. A good tutorial can be found here: http://www.w3schools.com/sql/sql_join.asp

Or is your question about how to join two different fields to the same table? In which case, you do it the same way you would a normal join, except you do it twice. You bring in the individuals table two times and give each reference a different alias. Each time you join to a different field.
Mar 23 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.