How to use LIKE between two columns
shabarMay 12 2009 — edited May 13 2009Hi
If we have following columns, how can we use LIKE to link the tables
COLUMN A of Table X COLUMN B of Table Y
============== =============
74500000ADN 74500000FKGL
78920000KDE 78900000LJKE
2345454LKKLK 54545345FDFR
96226HIYYOPP 9622622KDJJG
"SELECT ............. FROM TABLE1 X, TABLE2 Y WHERE X.colA LIKE Y.colB
Will the above work correctly?
(Need to extract row 1,2 and 4 above)
rgds
shabar