[v4rb v1] sql help with LEFT OUTER JOIN

[Ivan Smahin]

Robert Nichols wrote:
> What do you call that type of statement? Is it also a left outer  join, 
> but requested in a manner different from what I showed?
> 

Actually it is deprecated by SQL-92 join-syntax.
It is used in the "WHERE" clause

1.
"...WHERE t1.f1 *= t2.f2..."
"...FROM t1 LEFT OUTER JOIN t2 on t1.f1 = t2.f2..."

2.
"...WHERE t1.f1 =* t2.f2..."
"...FROM t1 RIGHT OUTER JOIN t2 on t1.f1 = t2.f2..."

3.
"...WHERE t1.f1 *=* t2.f2..."
"...FROM t1 FULL OUTER JOIN t2 on t1.f1 = t2.f2..."

4.
"...WHERE t1.f1 = t2.f2..."
"...FROM t1 INNER JOIN t2 on t1.f1 = t2.f2..."



Valentina 2 supports both syntaxes.


-- 
Best regards,
Ivan Smahin