Re: JOIN & Query Problem - unique indexes & PKs, converting FoxPro to MySQL
Posted by: Grind Stone
Date: November 03, 2011 11:40AM

I don't normally respond to my own messages, but...

To simplify my question without all the background info:

How does one create a JOIN on 2 Unique Index fields that have different lengths, and spaces before the actual data (actual data is a 5 digit order number)?

The fields involved in the JOIN (I used underscores to show the spaces in the record):

orderid.orderstable 12 characters _ _ _ _ _ _ _12345

orderid.invoicetable 8 characters _ _ _12345

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: JOIN & Query Problem - unique indexes & PKs, converting FoxPro to MySQL
2613
November 03, 2011 11:40AM


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.