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/my***********...ie.nctu.edu.tw