SQL query: Join on similiar fields
Posted on 2009-03-30
I have a situation where I need to join tables on a fields with different values. In one table, the patient# uses hyphens and the second table does not. I am joining the tables on patient#. Any idea how i can do this? Maybe i can create another table/qry/view that strips out the hyphen?
Here is an example of my problem,