Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Posts
    229

    Unanswered: No table between FROM and JOIN

    I've heard someone saying that it's possible to do a JOIN something like this:

    select a from join ....

    or if it's maybe

    select a from (join ...

    That is, there's no table between FROM and JOIN.

    I might be misinterpreting the DBv9 SQL Reference, but I can't find
    any support for this syntax.

    Does someone know...?

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    I've never heard about such a syntax. Plus: it's outside SQL-92

  3. #3
    Join Date
    Jul 2002
    Posts
    229
    Are all the JOIN constructions outside SQL-92 ?

    (When I learnt SQL at the university back in -91, the JOIN
    constructions were never mentioned at all.)

  4. #4
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Oh no.
    What I wanted to say was that the standard syntax is something like:

    table reference [join type] JOIN table reference

  5. #5
    Join Date
    Jul 2002
    Posts
    229
    Yes, exactly. There must be a table before the join verb(s).
    Can't figure out where the guy who mentioned the syntax I first
    described got it from.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •