why cant i wrap my head around this query?

Question

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Will this do what you need?

select *

from dbo.MyTable

where BLNA = 'True'

and exists

(select *

from dbo.MyTable T2

where FK1 = MyTable.FK1

and BLNA = 'False')

or BLNA = 'False'

and exists

(select *

from dbo.MyTable T3

where FK1 = MyTable.FK1

and BLNA = 'True');

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

trilobyte Grasshopper Points: 13 More actions · Answer 2

Grasshopper

Points: 13

December 4, 2009 at 1:31 pm

that's excatly what i wanted to do!

Thanks!

GSquared SSC Guru Points: 260824 More actions · Answer 3

You're welcome.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

trilobyte Grasshopper Points: 13 More actions · Answer 4

G2-

So does that actually create simulated tabnles doing the T2?

Kind of like a self join?

Anyways, thanks again!

GSquared SSC Guru Points: 260824 More actions · Answer 5

It's pretty much a special form of self-join. Not sure what you mean by "simulated tables".

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon