Using Right() inside SQL Join

15 pts.
Tags:
MySQL functions
RIGHT JOIN
SQL join
I need to join two tables where one table uses 0809 as data in the field and the other table uses 200809. Can this be done? Can I use a Right() statement in the join? Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

What hardware and software are you using?

———–

Yes, you can do that on MySql.

Remember that aplying functions to fields in the where clause, prevents the database system from using indexes.

-CarlosDL

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JeffCreek
    Sorry... I am using MS SQL 2005
    15 pointsBadges:
    report
  • carlosdl
    The same answer applies.
    69,510 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following