我如何...从两个表中获取多列信息?

问题描述:

此查询是否正确

is this query is right

SELECT username,password login_for_all.mis
FROM kvch_info_centre.member
INNER JOIN login_for_all ON kvch_info_centre.member.Activation_Code =login_for_all.Activation_Code where username='".$_POST['fname']."' and Password='".md5($_POST['pass'])."' and mis="Yes"

_POST [' fname ' ]。' 密码= ' 。md5(
_POST['fname']."' and Password='".md5(


_POST [' pass ' ])。' mis =
_POST['pass'])."' and mis="Yes"


您的查询必须以开头开头双引号

,最后一部分应该是

You query must have started with an opening double quote "
and the last part should be
mis='Yes'"