Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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: 13975
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: Fri May 03 23:42:24 CEST 2024

Total time taken to generate the page: 0.03098 seconds