need help in sql...........

Question

0.00/5 (No votes)

See more:

sir, i have 2 sql query like:-

1) select courseid,sem,period from table1
Output :-

101--1--3

2) select courseid,sem,period from table2
output:-

101--1--3
102--3--5

now i need a query that compare table2 with table1 and give me that column in with output are same.. it means (100--1--3). how can i do it..

Posted 16-Jan-15 0:42am

TCS54321

Add a Solution

Comments

CHill60 16-Jan-15 6:51am

Have you tried anything?

Er. Puneet Goel 16-Jan-15 6:52am

What type of compare you want ? Can you give some better example. As table 2 has 2 rows and table one has 1.So which type of compare ?

deepakdynamite 16-Jan-15 7:05am

use Inner join...

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)

CHill60 · Answer 1 · 2015-01-16T00:57:00

An Inner Join on both tables will produce what you need e.g.

SQL

select t1.courseid, t1.sem, t1.period
from table1 t1
inner join table2 t2 on t1.courseid = t2.courseid and t1.sem = t2.sem and t1.period=t2.period

For further information about Joins see this CP article Types of Join in SQL Server[^]

Niju1 · Answer 2 · 2015-01-16T01:08:00

Solution 2

if you want only distinct results use

SQL

select courseid, sem,period
from table1 
INTERSECT
select courseid, sem,period 
from table2

Posted 16-Jan-15 1:08am

Niju1

Updated 17-Jan-15 0:52am

v2