sql - How to properly join these selects? -



sql - How to properly join these selects? -

[1] select x.id somwhere x.location = _stringreturnedfromc#_ // need id table, know strin: location (from c#) [2] select y.nameid _relationbetweenxandy_ xy xy.id = [1] // utilize id found in [1] [3] select z.name z z.nameid = [2] // utilize id found in [2]

now how can tell select [2] looking xy.id = result select [1]

and select [3] i'm looking name of guy id z.nameid

i asked question here far i'm concerned question beyond saving.

z table: z.name, z.nameid y table: y.place, y.placeid // fixed, used placeid, inface string: place x table: x.name, x.placeid

if have same name, foreign keys (nameid, placeid)

this how actual code looks like:

select * angajati bring together distribuire d on d.locatie = 'oradea' // need d.distribuireid while know d.locatie (d.location). how ? bring together angajari on d.distribuireid = an.distribuireid

thus

select * tablex x bring together tabley y on x.placeid = y.placeid bring together tablez z on y.nameid = z.nameid

does not work because don't know y.placeid, know y.place

last edit

sorry if getting long. here how should (what mean that, if syntax won't work, logic) need syntax this!

select d.distribuireid distribuire d d.locatie = 'oradea' bring together angajari on an.distribuireid = d.distribuireid /*here i'd need an.angajatid locationid selected*/ bring together angajati on a.angajatid = an.angajatid

looks need inner joins:

select * tablex x bring together tabley y on x.placeid = y.placeid bring together tablez z on y.nameid = z.nameid

hope helps.

-edit -- why won't work? sorry if i'm not understanding question...

select d.distribuireid distribuire d bring together angajari on an.distribuireid = d.distribuireid bring together angajati on a.angajatid = an.angajatid d.locatie = 'oradea'

good luck.

sql sql-server-2012

Comments

Post a Comment

Popular posts from this blog

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more

Hibernate criteria by a list of natural ids -

Hibernate criteria by a list of natural ids - i trying create hibernate criteria using list of natural ids. saw illustration here http://docs.jboss.org/hibernate/core/3.5/reference/en-us/html/querycriteria.html#query-criteria-naturalid shows illustration querying single record: session.createcriteria(user.class) .add(restrictions.naturalid() .set("name", "gavin") .set("org", "hb")); is there improve way create criteria list of natural ids illustration below? junction junction = restrictions.disjunction() .add(restrictions.naturalid() .set("name", "gavin") .set("org", "hb")) .add(restrictions.naturalid() .set("name", "jdoe") .set("org", "rh")); session.createcriteria(user.class) .add(junction); thanks. in experience, no. reason due limitations of sql in implementations. when seek phrase in sql gets...
Read more

ios - Lagging ScrollView with UIWebview inside -

ios - Lagging ScrollView with UIWebview inside - i have uiwebview within uiscrollview lot of content. when content loaded uiwebview big, starts lag. does know how solve issue? maintain in mind lags when uiwebview's height becomes considerably big. thank in advance! if read documentation on uiwebview , states not embed uiwebview uitableview or uiscrollview . doing leads unexpected behaviour, , think experiencing first hand. sorry bearer of bad news. update - specific warning apple docs: the documentation addresses issue specifically. important: should not embed uiwebview or uitableview objects in uiscrollview objects. if so, unexpected behavior can result because touch events 2 objects can mixed , wrongly handled. apple reference on uiwebview . update 2: after doing few searches (search link, same posted in comments), came across this answer, may provide insight. monitors content offset in both uiscrollview , uiwebview via delegates, , cle...
Read more