U++ forum: Welcome to the forum

Search on this site

Search in forums

Fri, 23 December 2011 08:40

mirek
Messages: 14267
Registered: November 2005

Ultimate Member

To replace "in" (nested select), you have to use normal InnerJoin, not LeftJoin.

I suppose that this should work:

Select(myData.Of(TABLE_A)).From(TABLE_A)
.InnerJoinRef(TABLE_B).On(AGE.Of(TABLE_B) == xxxxxx).Where(A_REF_C.Of(TABLE_A) == yyyyyy);

Here I expect yyyyyy to be single value, not to represent another "in"...

[Updated on: Fri, 23 December 2011 08:48]

		Sql: *JoinRef By: mirek on Fri, 09 December 2011 14:14
		Re: Sql: *JoinRef By: Didier on Thu, 22 December 2011 00:22
		Re: Sql: *JoinRef By: mirek on Thu, 22 December 2011 08:17
		Re: Sql: *JoinRef By: Didier on Thu, 22 December 2011 17:26
		Re: Sql: *JoinRef By: Didier on Thu, 22 December 2011 23:10
		Re: Sql: *JoinRef By: mirek on Fri, 23 December 2011 08:40
		Re: Sql: *JoinRef By: mirek on Fri, 23 December 2011 08:48
		Re: Sql: *JoinRef By: Didier on Fri, 23 December 2011 17:24
		Re: Sql: *JoinRef By: mirek on Fri, 23 December 2011 17:26
		Re: Sql: *JoinRef By: mirek on Fri, 10 February 2012 19:12
		Re: Sql: *JoinRef By: Didier on Sat, 11 February 2012 09:31

Previous Topic:	Settings and multiple ide instances
Next Topic:	DataSource

Goto Forum:

] [

]

Current Time: Sun Aug 24 13:29:32 CEST 2025

Total time taken to generate the page: 0.04210 seconds