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..
How would i do that?
Thank you
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..
How would i do that?
Thank you