Combining Record Sets

[mtorbin]

The following query gives me an "invalid character" error:

SELECT     U.userid,
        U.firstname,
        U.initials,
        U.lastname,
        A.addr1,
        A.addr2,
        A.city,
        A.stateprov,
        A.country,
        A.postalcode,
        A.phone 
FROM     cr_users As U
        Left Join cr_useraddr As A
          On U.userId = A.userId
WHERE     A.userid IN ('1435335','1034861','1425675','1425855')

Why?

- MT

 

[SantaMufasa]

MT,

To help us troubleshoot your issue, could you please post a screen copy and paste of your SQL*Plus attempt to execute your code, down through the error message itself.

Also, it would be helpful for you to post a DESCRIBE of both your "cr_users" and "cr_useraddr" tables.

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]