SQL Basics

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesSQL Basics

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old December 9th, 2016, 03:51 PM
deva_123 deva_123 is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Dec 2016
Posts: 1 deva_123 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 24 m 29 sec
Reputation Power: 0
Nested Query help in SQL

Hi All,

I need a SQL query for extract all rows from table A and table B(Full Outer Join) and condition if any common rows then pick only from
table B.

TableA
ID Name CODE
1 Amazon 454
2 Walmart 454
3 Target 456
4 NewEgg 454

TableB
ID Name CODE1
1 Amazon.Com 456
5 Bliss World LLC 456
6 ONE KINGS LANE 454
Result:
ID NAME CODE CODE1
1 Amazon.Com(From tableB) 454 456
2 Walmart 454 NULL
3 Target 456 NULL
4 NewEgg 454 NULL
5 Bliss World LLC NULL 456
6 ONE KINGS LANE NULL 454

Last edited by deva_123 : December 9th, 2016 at 03:54 PM.

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesSQL Basics > Nested Query help in SQL


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap