U++ framework: U++ community news and announcements

Home » Community » U++ community news and announcements » Sql: *JoinRef

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Sql: *JoinRef [message #34971 is a reply to message #34969]

Thu, 22 December 2011 08:17

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

Didier wrote on Wed, 21 December 2011 18:22

Hi,

What syntax can I use to serialize more than one join at a time.

Take the following stupid .sch example:

TABLE_(TABLE_B)
	INT_    (B_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (AGE)
END_TABLE

TABLE_(TABLE_C)
	INT_    (C_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (WEIGTH)
END_TABLE

TABLE_(TABLE_A)
	INT_    (A_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (A_REF_B) REFERENCES(TABLE_B)
	INT_    (A_REF_C) REFERENCES(TABLE_C)
	INT_    (A_SIZE)
END_TABLE

I would like to write something like:

Sql * Select(myData).From(TABLE_A)
      .LeftJoinRef(TABLE_B).Where(AGE == xxxx)
      .LeftJoinRef(TABLE_C).Where(WEIGHT == yyyy)

Is this possible ??

This one no. The answer depends on what kind of SQL do you want to produce.

I think the most sense makes this:

Sql * Select(myData).From(TABLE_A)
      .LeftJoinRef(TABLE_B).On(AGE == xxxx)
      .LeftJoinRef(TABLE_C).On(WEIGHT == yyyy)

(but it is not 'where', because we have left joins, so AGE or WEIGHT would yield null, which would exclude such records when placed in where).

Mirek

Report message to a moderator

[Message index]

		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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 06 01:57:47 GMT+2 2026

Total time taken to generate the page: 0.00690 seconds