select a.*,b.auditState from a left join b on a.id=b.personid
select a.*,b.auditState from a ,b where a.id=b.personid
SELECT A.*,B.auditState FROM A,B WHERE A.ID=B.personid
select a.*,b.auditState from a ,b where a.id=b.personid
谢谢各位,楼上各位写的基本正确, 我还想问句能加条件查询吗? select tp.id, tp.sex,tp.personname,tp.nation,tp.birthtime,tp.marriage,tp.school, tp.professional,tp.literacy,tp.homephone,tpa.auditState2 from t_personinformation tp where tp.personname like '%ddd%' or tp.idnumber like '%" ddd "%' or tp.homephone like '%"111"%' left join t_personAudit tpa on tp.id=tpa.personid order by tp.id desc这样写对吗?主要是where段的
select tp.id, tp.sex,tp.personname,tp.nation,tp.birthtime,tp.marriage,tp.school, tp.professional,tp.literacy,tp.homephone,tpa.auditState2 from t_personinformation tp left join t_personAudit tpa on tp.id=tpa.personid where tp.personname like '%ddd%' or tp.idnumber like '%" ddd "%' or tp.homephone like '%"111"%' order by tp.id desc
select tp.id, tp.sex, tp.personname, tp.nation, tp.birthtime, tp.marriage, tp.school, tp.professional, tp.literacy, tp.homephone, tpa.auditState2 from t_personinformation tp left join t_personAudit tpa on tp.id=tpa.personid where tp.personname like '%ddd%' or tp.idnumber like '%ddd%' or tp.homephone like '%111%' order by tp.id desc
from a left join b on a.id=b.personid
from a ,b where a.id=b.personid
FROM A,B
WHERE A.ID=B.personid
from a ,b
where a.id=b.personid
我还想问句能加条件查询吗?
select tp.id, tp.sex,tp.personname,tp.nation,tp.birthtime,tp.marriage,tp.school,
tp.professional,tp.literacy,tp.homephone,tpa.auditState2 from t_personinformation tp where tp.personname like '%ddd%' or tp.idnumber like '%" ddd "%' or tp.homephone like '%"111"%' left join
t_personAudit tpa on tp.id=tpa.personid order by tp.id desc这样写对吗?主要是where段的
tp.professional,tp.literacy,tp.homephone,tpa.auditState2
from t_personinformation tp left join
t_personAudit tpa on tp.id=tpa.personid
where tp.personname like '%ddd%'
or tp.idnumber like '%" ddd "%'
or tp.homephone like '%"111"%'
order by tp.id desc
tp.id,
tp.sex,
tp.personname,
tp.nation,
tp.birthtime,
tp.marriage,
tp.school,
tp.professional,
tp.literacy,
tp.homephone,
tpa.auditState2
from
t_personinformation tp
left join t_personAudit tpa on tp.id=tpa.personid
where tp.personname like '%ddd%' or tp.idnumber like '%ddd%' or tp.homephone like '%111%'
order by tp.id desc
马上结贴!