Join syntaxes not all defined

2001-11-03 Thread Uriel Wittenberg
The manual's description of Join Syntax lists the various kinds of syntax but doesn't define some of them, e.g.: table_reference, table_reference and table_reference INNER JOIN table_reference join_condition I'm guessing these two are equivalent, except that you can't use a join_condition

RE: Join syntaxes not all defined

2001-11-03 Thread Carsten H. Pedersen
The manual's description of Join Syntax lists the various kinds of syntax but doesn't define some of them, e.g.: table_reference, table_reference and table_reference INNER JOIN table_reference join_condition Yes, it does. I'm guessing these two are equivalent, except that you can't

Re: Join syntaxes not all defined

2001-11-03 Thread Uriel Wittenberg
section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... Carsten H. Pedersen ?? Since this does not appear in the manual for v. 3.23.42, which

RE: Join syntaxes not all defined

2001-11-03 Thread Carsten H. Pedersen
section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... Carsten H. Pedersen ?? Since this does not appear in the manual for v.