表A:
smsid content
1 A
2 B
3 C
4 D
表B:
id send
1 M
2 N
3 M
问怎么样合并表A与表B得到表C???
表C:
smsid content send
1 A M
2 B N
3 C M
smsid content
1 A
2 B
3 C
4 D
表B:
id send
1 M
2 N
3 M
问怎么样合并表A与表B得到表C???
表C:
smsid content send
1 A M
2 B N
3 C M
select a.smsid, a.content, b.send from a, b
where a.smsid = b.id
就这么简单的查询,还弄个高薪水,谁信呀
select a.smsid, a.content, b.send from a, b
where a.smsid = b.id
select smsid,content,send from A right join B on smsid=id这样D事,怎么就没让我撞到,难道馅饼砸到LZ了?