表A:
a | ||
id | a | b |
1 | 1 | 4 |
2 | 2 | 5 |
3 | 3 | 6 |
表B:
b | |
id | sign |
1 | ! |
2 | # |
3 | @ |
4 | $ |
5 | % |
6 | ^ |
结果:
a | sign | b | sign1 |
1 | ! | 4 | $ |
2 | # | 5 | % |
3 | @ | 6 | ^ |
SQL语句:
select a.a,b1.sign,a.b,b2.sign
from a
inner JOIN b b1 ON(a.a = b1.id)
inner join b b2 on(a.b = b2.id)
表A:
a | ||
id | a | b |
1 | 1 | 4 |
2 | 2 | 5 |
3 | 3 | 6 |
表B:
b | |
id | sign |
1 | ! |
2 | # |
3 | @ |
4 | $ |
5 | % |
6 | ^ |
结果:
a | sign | b | sign1 |
1 | ! | 4 | $ |
2 | # | 5 | % |
3 | @ | 6 | ^ |
SQL语句:
select a.a,b1.sign,a.b,b2.sign
from a
inner JOIN b b1 ON(a.a = b1.id)
inner join b b2 on(a.b = b2.id)