Difference between a CROSS JOIN and a 'comma'

• TomThomson

  SSC Guru

  Points: 104773

  More actions

  September 15, 2012 at 8:41 am

  #1538274

  SQL Kiwi (9/14/2012)

  ---

  Peter Brinkhaus (9/14/2012)

  ---

  Looking at the syntax definition of the FROM clause the binding error makes perfect sense.

  That does make sense, thanks!

  BTW: Never post anything ever again, Peter. You have the much-coveted 'default port' status (for a point score of 1433).

  edit: Oh. You've changed to 'UDP Broadcaster' (1434).

  Not only does it make sense, it provides an extremely good reason to parse it that way. If you have a BNF definition of some construct, parsing it according to that BNF definition makes sense, and restricting the ON clause of a join so that it can refer only to columns of the tables being joined is also perfectly good sense; failing to do either of those things doesn't make sense.

  Tom