Access数据库 ADOQuery1.Close;
ADOQuery1.SQL.Text:='select Table1.Field1 from Table1 join Table2 On Table1.Field1=Table2.Field1 and Table1.Field2<>Table2.Field2;
ADOQuery1.open;
ADOQuery1.SQL.Text:='select Table1.Field1 from Table1 join Table2 On Table1.Field1=Table2.Field1 and Table1.Field2<>Table2.Field2;
ADOQuery1.open;
前面加上ADOQuery1.SQL.clear;
在试一市
adoquery1.sql.clear;
ADOQuery1.SQL.Text:='select Table1.Field1 from Table1 inner(left right)
join Table2 On Table1.Field1=Table2.Field1 and Table1.Field2<>Table2.Field2;
ADOQuery1.open;
ADOQuery1.Close;
ADOQuery1.SQL.Text:='select Table1.Field1 from Table1 join Table2 On Table1.Field1=Table2.Field1 and Table1.Field2<>Table2.Field2';
ADOQuery1.open;
ADOQuery1.Close;
ADOQuery1.Clear;
ADOQuery1.SQL.Text:='select Table1.Field1 from Table1 join Table2 On Table1.Field1=Table2.Field1 and Table1.Field2<>Table2.Field2';
ADOQuery1.open;