begin
Query.sql.clear;
Query.sql.add('select * from 表1');
Query.open;
while Query.eof<>true do
begin
combobox.idems.add(Query.fieldbyname('字段').astring);
Query1.next;
end;
end;
Query.sql.clear;
Query.sql.add('select * from 表1');
Query.open;
while Query.eof<>true do
begin
combobox.idems.add(Query.fieldbyname('字段').astring);
Query1.next;
end;
end;
用上面的SQL就可以
combobox.items.add(fieldbyname('name'));
Union //warning!! NOT union all
Select 表2的字段1 as Field1 From Table2
然后你再ComBoBox1.Items.Add(........希望你能明白
呵呵
谢谢:我的意思是,读表一的字段,但是,表一的字段和表二的字段的值有些是一样的,我只想读不一样的;也就是说,表一的值包含于表二,但是,我只想要表一的集合里减去表二的集合的值
我的目的是:select * from b1 where name not in (select name from b2) 可以正确执行;
query.SQL.add('select fieldname from table1_name where fieldname not in (select table2_name from table2_name)');
query.Open;
combobox1.Clear ;
with query do
begin
first;
while not (query.Eof ) do
begin
combobox1.Items.Add(fieldbyname('fieldname').asstring);
Next;
end;
end;
这下你再看去吧,细心一点好不好???