建议用ADOQuery,下面的代码可以达到你的目的youfield是另一个表的字段
fieldx,fieldy分别是表1和表2的相关字段
with adoquery do
begin
Close;
SQL.Clear;
SQL.Add('SELECT A.*,B.youfiled ');
SQL.Add(' FROM table1 A, ');
SQL.Add(' table2 B ');
SQL.Add(' WHERE A.fieldx = B.Fieldy ');
Open;
end;
fieldx,fieldy分别是表1和表2的相关字段
with adoquery do
begin
Close;
SQL.Clear;
SQL.Add('SELECT A.*,B.youfiled ');
SQL.Add(' FROM table1 A, ');
SQL.Add(' table2 B ');
SQL.Add(' WHERE A.fieldx = B.Fieldy ');
Open;
end;
fieldx,fieldy分别是表1和表2的相关字段
with adoquery do
begin
Close;
SQL.Clear;
SQL.Add('SELECT A.*,B.youfiled ');
SQL.Add(' FROM table1 A, ');
SQL.Add(' table2 B ');
SQL.Add(' WHERE A.fieldx = B.Fieldy ');
Open;
end;