U++ framework
Do not panic. Ask here before giving up.

Home » U++ Library support » U++ SQL » [sql] Select embeded in join
Re: [sql] Select embeded in join [message #22924 is a reply to message #22914] Sat, 29 August 2009 00:18 Go to previous messageGo to previous message
mirek is currently offline  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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
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