Results 1 to 2 of 2

Thread: Joins

  1. #1
    Join Date
    Feb 2003

    Unanswered: Joins

    I have two tables, one called users and the other resources.
    I'd like to select several fields from users and one from Resource (called ResourceID) based on certain criteria.

    My sql statement looks like this:

    gstrSQL = "Select UserNum, ResourceID, UserFName, UserLName, Password, SecurityLevel, email, Telephone, ext, UserID from Users U, Resource R where "

    If UserNum <> "" Then
    gstrSQL = gstrSQL & "UserID='" & UserNum & "' And u.userfname = r.fname and u.userlname = r.lname"
    gstrSQL = gstrSQL & "UserID='" & UserID & "' And u.userfname = r.fname and u.userlname = r.lname"
    End If

    Before adding "ResourceID" to the selection criteria, this statement was working just fine. It's probably a silly mistake but I can't figure it out.

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    You didn't let us know the DB you're working on, nor the error itself ...

    In Oracle you can NOT name your table "Resource" as it is reserved word.

    However, if your DB allows it, try to rewrite the query in a way to put table aliases in front of table columns, i.e.
    PHP Code:
    SELECT u.UserNumr.ResourceIDu.UserFName, ...
    FROM Users UResource R
    Perhaps your tables contain the same column names and, if you don't explicitly say the table you are selecting its value from, the column becomes ambigously defined.

Posting Permissions

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