sql语句问题

Question

表1                                       表2
col1 col2                               col1   col2
1     a                                   1     z
2     b                                   2     y
3     c                                   3     x
4     d                                   4     w
select a.col1,a.col2,b.col2 from 表1 a,表2 b where a.col1 *= b.col1