Click here to Skip to main content
13,086,019 members (85,721 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
I have 4 tables
table 1 has 1 column named car
table 2 has 2 columns named car and name
table 3 has 3 columns car ,name, and group
table4 has 4 columns named car ,name,group, owner i want to likn k the coulmns in the tables so that car,name,group in table1,2and 3 are the same
Posted 17-Sep-12 23:07pm
mrDivan1.2K
Updated 17-Sep-12 23:10pm
v2
Comments
Zoltán Zörgő 18-Sep-12 5:10am
   
Good for you, and how can we help? This is no question.
shabari7 18-Sep-12 5:16am
   
try foreign key concept

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hi,
you can use primary key and foreign key concept.
like keep car as primary key in table1 and give its reference to all three tables.
in same way for name and group in their respective tables.
it will help to remove data redundancy.
  Permalink  
Comments
mrDivan 18-Sep-12 6:25am
   
Thank you

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web03 | 2.8.170813.1 | Last Updated 18 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100