Help with SQL

[masha2008]

Im making a Join

Select Table1
      
   From Tables

  Where Table1=Table2

Table1   Table2
09876    Q9876
09871    Q9871
02345    Q2345
09867    Q9867

I need to join these two tables, and pull Table1, however I still need for that letter Q to be equal to '0' and I need to keep the zero in front of the number..

Im trying to use REPLACE

 SELECT Table1, 
       Table2,

FROM  ACCT_HIST left join
         ACCT_LIST on (Table1 = replace table2 ,'Q','0' left join

I keep getting this error expected something between = and REPLACE.

What am I doing wrong?

Thank you

 

[steph22]

Would something like this work for you?

SELECT table1
FROM ACCT_HIST a
            ,ACCT_LIST  b
WHERE SUBSTR(TRIM(table1), 2, LENGTH(TRIM(table1))-1) = SUBSTR(TRIM(table2), 2, LENGTH(TRIM(table2))-1)

Results:

table1
09871
09876
02345
09867