[Show all top banners]

NepaliBhai
Replies to this thread:

More by NepaliBhai
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Discussion Refresh page to view new replies
 SQL Help
[VIEWED 2151 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 7 days
Recommended Popular Threads Controvertial Threads
TRUMP 2016!!! Here is why?
US upcoming recession --- is it good time to buy house when rates are low or is it good time to wait recession?
travel from nepal to US amid corona virus
TPS TO GC TO AOS INTERVIEW
Pete Buttigieg is the new Hillary Clinton
Send money in Nepal
American Idol मा पहिलोपटक नेपाली केटाेकाे यस्तो दम्दार प्रस्तुति | Dibesh Pokharel | Arthur Gunn
Wow ... सोनिकालाइ हिराको हार र चुम्बन
Best Java Training
Democrat’s presidential nominee should have Mitt Romney as VP
TRUMP 2016!!! Here is why?
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