← Back to Kurakani

Help in SQL Query

Original Post

Hi SQL Gurus, I need to join two tables say Table I and Table W Table I is like below Numbers Values 1 A 1 B 2 C 3 D Table W is Like Below Numbers Boolean 1 Yes 1 Yes 2 Yes 3 Yes I need to query to join Table I and W where Boolean value is Yes in Table W but there is no D in Table I in Oracle database. The answer would be Number 1 2 Can someone help me get a query?

Ghiraunla
May 2, 2017 6:01 AM · 18,652 views
8 Replies
pidiiit May 2, 2017 7:45 AM
Hey, your requirement is confusing. What does it mean by "where Boolean value is Yes in Table W but there is no D in Table I in Oracle database"
panacea May 2, 2017 7:45 AM
If there is no value D in table I then when you join both the tables on numbers, you will automatically get the those two numbers as you distinct them. Not sure, what your question is actually?
KaliKoPoi May 2, 2017 8:41 AM
First join like this: select i.Numbers as Number from I i join W w on i.Numbers = w.Numbers Then use filter to get the record you need: where w.Boolean="Yes" and i.Values != 'D' Actual query depends on database you are using.
jaxnepali May 2, 2017 9:29 AM
try this..very generic select * from i where values <> 'D' and numbers in (select numbers from w where boolean = 'Y') - Jaxnepali Last edited: 02-May-17 09:29 AM
c864916 May 2, 2017 12:11 PM
There is an online application for testing and sharing SQL queries called SQLFiddle.com. Here's a quick fiddle I created for you. http://sqlfiddle.com/#!9/393cc...
ikauda May 2, 2017 12:34 PM
are you interested in basic to advance level SQL training please contact hr@ikauda.com ----- New QA training session starting this wednesday( 05/02/2017)
daniachhetri_geekIt May 2, 2017 12:49 PM
ikauda, How much do you charge for your trainings? Thank you, Dania Dania Chhetri Senior Resource Manager Geek IT Solution LLC Email: dania@geekitsolution.com Direct: 972-358-3131 Linkedin: Dania Chhetri Google Hangout: geekitsolution.midwest@gmail.com Note: If you were unable to reach me please contact our President, Santosh Bhattarai at santosh@geekitsolution.com or you may call him at: 913-515-5346. He can also be reached on hangouts at: geekit.kansas@gmail.com
ikauda May 2, 2017 1:29 PM
zero cost....... thousands to benefit ( to candidates)...... Last edited: 02-May-17 01:29 PM Last edited: 02-May-17 01:31 PM
Login to join the conversation.

You might be interested in...

Latest Kurakani View all
Page 1 of 34
Recent Classifieds View all
Page 1 of 32
Upcoming Events View all
Service Providers View all
Page 1 of 23
Ask Sajha AI Assistant