Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    8

    Unanswered: Query problem with numbers

    Hey there,

    I am having difficulties with generating a query. One table I have school code 01, 02, 03 and another table I have same school code 1, 2, 3. How do I generate query Without changing anything?

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Code:
    SELECT *
    FROM foo
    JOIN bar ON foo.school_code::int = bar.school_code::int

Posting Permissions

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