如果服务器是SQL SERVE,可以这样试试: select isnull(B.name,'控制中心') as name,A.jqname,A.ip from coip A,corp B where A.coid=b.coid
select B.name,A.jqname,A.ip from coip A,corp B where A.coid=b.coid uion Select B.Name='控制中心',A.jqname,A.ip From Coip A,Corp B Where A.Coid not in (Select coid from corp)
select B.name as name,A.jqname as jqname,A.ip as ip from coip A,corp B where A.coid=b.coid union (select '控制中心' as name,A.jqname as jqname,A.ip as ip from coip A where a.coid not in (select b.coid from corp b)
同志们呀这样写在sql中是对的可是放到delphi中就编译不了:555555with query do begin close; sql.clear sql.add(' select B.name as name,A.jqname as jqname,A.ip as ip from coip A,corp B where A.coid=b.coid union'); sql.add('select '控制中心' as name,A.jqname as jqname,A.ip as ip from coip A where a.coid not in (select b.coid from corp b) ') open; end
select isnull(B.name,'控制中心') as name,A.jqname,A.ip from coip A,corp B where A.coid=b.coid
uion
Select B.Name='控制中心',A.jqname,A.ip From Coip A,Corp B Where A.Coid not in (Select coid from corp)
union (select '控制中心' as name,A.jqname as jqname,A.ip as ip from coip A where a.coid not in (select b.coid from corp b)
begin
close;
sql.clear
sql.add(' select B.name as name,A.jqname as jqname,A.ip as ip from coip A,corp B where A.coid=b.coid
union');
sql.add('select '控制中心' as name,A.jqname as jqname,A.ip as ip from coip A where a.coid not in (select b.coid from corp b)
')
open;
end
在sql字符串中这样写根本就是不对呀....