现在有两个表
A
UID | IP |
1 111
1 112
2 211
2 212
1 111
3 311B
IP | MAC
111 abc
111 abb
211 bbb
212 bbc现在有两个表
每个用户有N个IP, 每个IP有N个MAC
我想查每个用户的IP,并且对映的MAC 改怎么写
最后应该是UID IP MAC
1 111 abc
1 111 abb
2 211 bbb
2 212 bbc
A
UID | IP |
1 111
1 112
2 211
2 212
1 111
3 311B
IP | MAC
111 abc
111 abb
211 bbb
212 bbc现在有两个表
每个用户有N个IP, 每个IP有N个MAC
我想查每个用户的IP,并且对映的MAC 改怎么写
最后应该是UID IP MAC
1 111 abc
1 111 abb
2 211 bbb
2 212 bbc
from A inner join B on A.IP=B.IP
order by UID,A.IP,MAC
from A,B
where A.ip=B.ip
from A inner join B on A.ip=B.ip
from a inner join b using (IP)