Home » U++ Library support » U++ SQL » [sql] Select embeded in join
Re: [sql] Select embeded in join [message #22914 is a reply to message #22879] |
Fri, 28 August 2009 12:06 |
Zbych
Messages: 326 Registered: July 2009
|
Senior Member |
|
|
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*/)); }
[Updated on: Fri, 28 August 2009 12:08] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Fri May 03 22:25:29 CEST 2024
Total time taken to generate the page: 0.02629 seconds
|