Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2009
    Posts
    3

    Unanswered: 01747. 00000 - "invalid user.table.column, table.column, or column

    01747. 00000 - "invalid user.table.column, table.column, or column specification"
    Error at Line: 142 Column: 34

    Having this error when trying to execute this code

    Code:
    select 
       ph2_customer.customer_id,
       ph2_customer.site_code,
       ph2_customer."name",
       area_manager.area_manager as salesperson_id,
       area_credit_limit.credit_lim. as credit_limit
       from
       ph2_customer
       join
       area_credit_limit
       on
       substr(ph2_customer.site_code,1,2) = area_credit_limit.area
       join
       ph2_state_region
       on
       ph2_state_region.state = area_credit_limit.area
       join
       area_manager
       on
       area_manager.state = ph2_state_region.regional_group

    has anyone got any ideas what is going on?

  2. #2
    Join Date
    Dec 2009
    Posts
    3
    Quote Originally Posted by r937 View Post
    your error is right here --
    Code:
       area_credit_limit.credit_lim. as credit_limit
    Cant see the error, can you elaborate?

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    your error is right here --
    Code:
       area_credit_limit.credit_lim. as credit_limit
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you have a table name followed by a period followed by a column name followed by a period

    think about it carefully, i'm sure you will see it soon

    refer back to the text of the error message for a clue

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Dec 2009
    Posts
    3
    oh my.....i did not see that, need more coffee, or more sleep.
    Thanks very much

Posting Permissions

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