[Show all top banners]

NepaliBhai
Replies to this thread:

More by NepaliBhai
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 SQL Help
[VIEWED 6096 TIMES]
SAVE! for ease of future access.
Posted on 01-15-14 1:32 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Please help me.
I have two tables.
First table has rows with some colums
Second table has rows with same colums and some other columns

I need to get rows that exist in table one but not in table two.
Please see the picture

I could not upload picture
Last edited: 15-Jan-14 01:33 PM

 
Posted on 01-15-14 2:22 PM     [Snapshot: 63]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

http://www.techonthenet.com/sql/joins.php

Please review the following link. This might help you for future reference too.
 
Posted on 01-15-14 2:29 PM     [Snapshot: 58]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

This really depends on the Relation between two tables. This could be the syntax for two tables containing same column say student_Id.

select *
from table one
where tableone.student_Id NOT IN
( Select tabletwo.student_ID
from table two) ;

 
Posted on 01-15-14 3:31 PM     [Snapshot: 151]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 
 
Posted on 01-15-14 3:34 PM     [Snapshot: 154]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

mvc,
That's not the proper way to do it. I know it works. But SQL query is not optimized in that Sub-query...............

Here it is

Select [Column lists...............]
FROM table1 a
LEFT JOIN table2 b
ON a.SameColumnName = b.SameColumnName
WHERE b.SameColumnName IS NULL


 
Posted on 01-15-14 3:53 PM     [Snapshot: 182]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 


Thank you all.
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 200 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration
What are your first memories of when Nepal Television Began?
निगुरो थाहा छ ??
ChatSansar.com Naya Nepal Chat
Basnet or Basnyat ??
Sajha has turned into MAGATs nest
NRN card pros and cons?
Do nepalese really need TPS?
कता जादै छ नेपाली समाज ??
susta manasthiti lai ke bhanchan english ma?
Nas and The Bokas: Coming to a Night Club near you
Will MAGA really start shooting people?
Democrats are so sure Trump will win
मन भित्र को पत्रै पत्र!
Top 10 Anti-vaxxers Who Got Owned by COVID
I regret not marrying a girl at least for green card. do you think TPS will remain for a long time?
TPS Work Permit/How long your took?
काेराेना सङ्क्रमणबाट बच्न Immunity बढाउन के के खाने ?How to increase immunity against COVID - 19?
Breathe in. Breathe out.
3 most corrupt politicians in the world
Nas and The Bokas: Coming to a Night Club near you
Mr. Dipak Gyawali-ji Talk is Cheap. US sends $ 200 million to Nepal every year.
Harvard Nepali Students Association Blame Israel for hamas terrorist attacks
TPS Update : Jajarkot earthquake
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters