Radicore Forum: How To » RIGHT JOIN in LINK

Home » RADICORE » How To » RIGHT JOIN in LINK

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

RIGHT JOIN in LINK [message #2647]

Sun, 02 January 2011 16:25

gpatti
Messages: 283
Registered: August 2008

Senior Member

Is it possible to create a LINK entity that restricts the number of possible combinations by using a RIGHT JOIN rather than a CROSS JOIN?

I can write the SQL to obtain the results I want but can only get the framework to generate a CROSS JOIN in a LINK transaction?

If not can I hardcode my statement to be used by a LINK transaction? I have tried setting $this->sql_select, $this->sql_from and $this->sql_where in _cm_pre_getData() but this generates a statement with both a CROSS JOIN and a RIGHT JOIN. I can't seem to avoid the CROSS JOIN!

Report message to a moderator

[Message index]

		RIGHT JOIN in LINK By: gpatti on Sun, 02 January 2011 16:25
		Re: RIGHT JOIN in LINK By: AJM on Mon, 03 January 2011 06:23
		Re: RIGHT JOIN in LINK By: gpatti on Mon, 03 January 2011 08:05
		Re: RIGHT JOIN in LINK By: AJM on Mon, 03 January 2011 09:55

Previous Topic:	grandparent - parent - child link entity
Next Topic:	Display combined fields on Output3 report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Nov 23 02:29:28 EST 2024

Total time taken to generate the page: 0.03061 seconds