U++ forum: Welcome to the forum

Search on this site

Search in forums

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

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

[sql] Select embeded in join [message #22815]

Tue, 18 August 2009 23:08

Zbych
Messages: 325
Registered: July 2009

Senior Member

Hi,

I need to embed select inside left join. I've found AsValue function, but I could not find anything that converts SqlSelect to SqlId, so I added this:

SqlId    AsTable(SqlId table) const               { return SqlId(String("(") << text << ")").As(table); }

to class SqlSelect.

Maybe it doesn't look to good, but it works.

Report message to a moderator

[Message index]

		[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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 20 15:05:40 CEST 2024

Total time taken to generate the page: 0.02217 seconds