use Perl

• Am I missing something? (Score:2)

  by Purdy (2383)

  How come you can't just say:
  
  SELECT id,
                first_name,
                last_name,
                other_table.id,
                other_table.name
  FROM some_view
  
  - Jason
  • Re:Am I missing something? (Score:2)

    by Ovid (2709)

    You have to quote them because it's invalid syntax if you don't them (unless you actually specify the other table in your "FROM" clause.) You see, the dot is standard syntax for indicating that you're pulling the data from another table:

    SELECT name, this.data
    FROM   bar, this
    WHERE  bar.this_id = this.id
    • Re:Am I missing something? (Score:2)

      by Ovid (2709) on 2005.01.13 17:36 (#37468) Homepage Journal

      Er, "if you don't quote them." :)

      Reply to This

      Parent