可以. 用这个命令: select table1.id,table1.xm,table2.xb from table1 left join table2 on table2.id=table1.id where ...........(如果有条件你自己加)
----------------------------------------------
delphi的忠实拥戴者 一起交流DELPHI MSN: tech@delphisoft.com.cn
select table1.id,isnull(table1.xm,'未知'),isnull(table2.xb,'未知') from table1 a left join table2 on table2.id=table1.id
----------------------------------------------
-和大家一起学习,一起进步!!!
select table1.id, isnull(table1.xm,'未知'), isnull(table2.xb,'未知') from table1 left join table2 on table1.id=table2.id;
----------------------------------------------
Function IThink(Boy,Girl : TPerson) : String; begin if Boy.钱 < 10W then Girl.Say(''滚!'') else begin if Girl.Anser = ''我愿意'' then Result := ''结婚'' else Result := IntToStr(88); end; 风过不折→百炼成尧 QQ: 7315910
----------------------------------------------
Function IThink(Boy,Girl : TPerson) : String; begin if Boy.钱 < 10W then Girl.Say(''滚!'') else begin if Girl.Anser = ''我愿意'' then Result := ''结婚'' else Result := IntToStr(88); end; 风过不折→百炼成尧 QQ: 7315910