56,679
社区成员
发帖
与我相关
我的任务
分享MYSQ问题？
How can i show data like this with 2 table as bellow?
name phone categoryid
kent 123 teacher
dav 222 teacher
wen 444 worker
A Table
name phone categoryid
kent 123 1
dav 222 1
wen 444 3
B Table
categoryid categoryname
1 teacher
2 student
3 worker
name phone categoryid
kent 123 teacher
dav 222 teacher
wen 444 worker
A Table
name phone categoryid
kent 123 1
dav 222 1
wen 444 3
B Table
categoryid categoryname
1 teacher
2 student
3 worker
...全文
请发表友善的回复…
发表回复
简叔 2004-01-29
- 打赏
- 举报
select a.name,a.phone b.categoryname
from a, b
where a.categoryid = b.categoryid;
Advice: Think it yourself before you send a new topic
from a, b
where a.categoryid = b.categoryid;
Advice: Think it yourself before you send a new topic
