A Gentle Introduction to

SQL

NEW.

These questions have been submitted by users.



How to substr tbl_nm_1.aaa to tbl_nm_2.bbb
I need to join 2 tables on sbscr_nmb. The problem that in first table value is 10-11 char long , and in second table it has '02', '01','00' at the end - that I don't care about. Could somebody give me an Idea how to do that?
access variations:
None

access
db2
mysql
oracle
postgres
sqlserver