Click here to Skip to main content
12,547,591 members (38,230 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQL
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
Updated 17-Sep-12 23:10pm
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
Please Sign up or sign in to vote.

Solution 1

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.
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 | Mobile
Web02 | 2.8.161018.1 | Last Updated 18 Sep 2012
Copyright © CodeProject, 1999-2016
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