| RIGHT JOIN in LINK [message #2647] |
Sun, 02 January 2011 16:25  |
gpatti
Messages: 287
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!
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
