U++ framework: U++ SQL » [sql] Select embeded in join

Home » U++ Library support » U++ SQL » [sql] Select embeded in join

Sat, 29 August 2009 00:18

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

Zbych wrote on Fri, 28 August 2009 06:06

luzr wrote on Mon, 24 August 2009 15:45

Please check, I hope this solves the problem.

Sorry for the delay. I've checked new version and it appears that postgres doesn't like double brackets. Query like this one:

select COLUMN
 from TABLE
 left outer join
 ((select COLUMN from TABLE1) as TABLE2)
 on TABLE.COLUMN = TABLE1.COLUMN1

is not accepted, so I had to remove "+1" from join:

SqlSelect& LeftJoin(const SqlSet& set)            { return LeftJoin0(~set(SqlSet::SETOP /*+ 1*/)); }

ok.

		[sql] Select embeded in join By: Zbych on Tue, 18 August 2009 23:08
		Re: [sql] Select embeded in join By: Zbych on Wed, 19 August 2009 16:32
		Re: [sql] Select embeded in join By: mirek on Mon, 24 August 2009 10:58
		Re: [sql] Select embeded in join By: mirek on Mon, 24 August 2009 15:45
		Re: [sql] Select embeded in join By: Zbych on Fri, 28 August 2009 12:06
		Re: [sql] Select embeded in join By: mirek on Sat, 29 August 2009 00:18
		Re: [sql] Select embeded in join By: mirek on Fri, 21 August 2009 14:30
		Re: [sql] Select embeded in join By: Zbych on Fri, 21 August 2009 15:59

Previous Topic:	Possible SqlOption Problem [Solved]
Next Topic:	Postgresql - execpt vs minus

Goto Forum:

] [

]

Current Time: Sun Jun 07 02:53:37 GMT+2 2026

Total time taken to generate the page: 0.00514 seconds