LEFT JOIN ON TRUE

The 1C:Enterprise developers forum

Pages: 1

erickruger

People who like this:0 Yes/0 No

Apr 11, 2012 02:06 PM

Active user

Rating: 5
Joined: Sep 27, 2011
Company:

What does LEFT JOIN … ON TRUE means and what is used for?
For example:

Code
\|LEFT JOIN TTDebtsCalculation AS DebtsCalculation \|ON TRUE

Samuel Harris

People who like this:0 Yes/0 No

Apr 11, 2012 06:07 PM

Active user

Rating: 3
Joined: Sep 16, 2011
Company: individual

This means that all rows of joined table will be joined to all rows of the result of tables joined above:
Table 1:

Code
1 1 2 2

Table 2:

Code
3 3 4 4

Result:

Code
1 1 3 3 1 1 4 4 2 2 3 3 2 2 4 4

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)