MySQL Forums
Forum List  »  Oracle

left outer join not working with fileaddress
Posted by: Roberto B.
Date: December 18, 2015 12:41AM

I have 2 table, let's say ltable and rtable, with a VARCHAR(255) field containing a fileaddress.
And i have to find all the fileaddresses in ltable that are not in rtable. And for that reason i use a left outer join like that:

SELECT * FROM ltable AS L
JOIN rtable AS R
USING (fileaddress)
WHERE R.fileaddress is NULL
ORDER BY L.fileaddress;

but with plain varchar (without :\,\...) it works and with :\,\... i am getting strange results.
I was thinking it was because some strange management of :\,\ in varchar but the value comes from a LOAD DATA INFILE and then move from a table to other by INSERT so the value should be the same ones.
Where am i getting wrong?
Thanks for your help

Options: ReplyQuote


Subject
Views
Written By
Posted
left outer join not working with fileaddress
2074
December 18, 2015 12:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.