菜鸟问题:两表关联的sql语句怎么写? select member.email,fourm.user,fourm.title,fourm.ip from fourm,member where fourm.user=member.id,按楼主说的是这样,不过fourm.user=member.id令人费解啊!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.email,b.user,b.title,b.ip form member a,fourm b where a.id=b.user select member.email fourm.* from member,fourm where member.id=fourm.user; 少一个逗号select member.email,fourm.* from member,fourm where member.id=fourm.user; 首先你要在member和fourm表建立关联再select member.email,fourm.user,fourm.title,fourm.ip from member,fourm where member.id=fourm.user;可以实现这样的操作 select member.email fourm.* from member,fourm where member.id=fourm.user; 试试这句:select f.user,f.title,f.ip,m.email from fourm as m left join member as m on f.user=m.id; php 获取frame的title php+ajax问题 echo()简化语法? 时间循环的问题,在线等 一个正则表达式的问题 急用~~谢谢 加减程序?急!急!急! 这算不算类,又没必要做成类 php命令行调用,后台运行的问题??? 需要php+sql源码一份 php怎么发送报文 和接收回应 我的PHP程序出错了!!!快来HELP一下啊! 请问select中的onchang是否可以同时传递两个值??
select member.email,fourm.* from member,fourm where member.id=fourm.user;
select member.email,fourm.user,fourm.title,fourm.ip from member,fourm where member.id=fourm.user;
可以实现这样的操作
select f.user,f.title,f.ip,m.email
from fourm as m
left join member as m
on f.user=m.id;