I need some help with a query. I have two tables in one data base that both have a SSN field. The ssn field in one table contains slashes and the ssn field in the other does not.
I know how to use CONCAT() and RIGHT(),MID(), and LEFT() on one of the ssn fields to obtain a result with digits only. But, I need to obtain a result set that includes a field from each table matched by ssn with one field from each. For example, let's say that table 'one' looks like this: '111/22/3333','John Q Public' Table 'two' looks like this: '11122333','somecode' What I'd like to achieve is a result set of: '111223333','John Q Public','somecode' I guess what's throughing me off is using CONCAT() with the other substring items. Can this be done with one query? Mucho appreciation for any advice or assistance. Thanks! ~Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
