Primary key problem in sql

Question

0.00/5 (No votes)

See more:

Is it possible that a column in one table primary key and the other column in another table with same datatype primary key? It is also mention that I will join two table

Posted 6-May-13 23:49pm

Sumon562

Add a Solution

Comments

vijay__p 7-May-13 5:53am

Can you please elaborate your question more in detail?

Sumon562 7-May-13 6:06am

I want to join two table with a common field and same datatype and both the field is primary key. I want to join the two table with the above mentioned field

Sumon562 7-May-13 6:22am

Hi patel_vijay . I have explained the question

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2013-05-06T23:55:00

Solution 1

Yes why not. That is the concept of Foreign Key[^].

The other column will be primary key in the other table and will be referenced in the first table as Foreign key.

Refer - SQL FOREIGN KEY Constraint[^].

So, depending on that column you can join.

SQL

SELECT columnName
FROM 
Table1
INNER JOIN
Table2
ON Table1.Column1 = Table2.Column1
-- (Add some condition if you want using WHERE)

Posted 6-May-13 23:55pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Sumon562 7-May-13 6:24am

Thank you. But I do not declare theTable2.Column1 column as foreign key. both columns are primary key.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-May-13 6:35am

Ok, Then do like this. It will fetch data. Have you tested ?

mojtaba1596 · Answer 2 · 2013-05-06T23:57:00

Solution 2

yes, It is possible if you have any problem please write your query.

Posted 6-May-13 23:57pm

mojtaba1596