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"

pidiiit · 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?

panacea · May 2, 2017 7:45 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.

KaliKoPoi · May 2, 2017 8:41 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

jaxnepali · May 2, 2017 9:29 AM

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...

c864916 · May 2, 2017 12:11 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)

ikauda · May 2, 2017 12:34 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

daniachhetri_geekIt · May 2, 2017 12:49 PM

zero cost....... thousands to benefit ( to candidates)...... Last edited: 02-May-17 01:29 PM Last edited: 02-May-17 01:31 PM

ikauda · May 2, 2017 1:29 PM