datamodule100.query2.close;
datamodule100.query2.sql.Clear;
datamodule100.query2.sql.add('select * from xiaoshoudanbiao where (huopinshuliang>(select huopinshangxian from xiaoshoudanbiao)) or (huopinshuliang>(select huopinxiaxian from xiaoshoudanbiao))');
showmessage(datamodule100.Query2.SQL.Text);
datamodule100.query2.open;
打开时报错;
报huopinshuliang,huopinshuliang错
datamodule100.query2.sql.Clear;
datamodule100.query2.sql.add('select * from xiaoshoudanbiao where (huopinshuliang>(select huopinshangxian from xiaoshoudanbiao)) or (huopinshuliang>(select huopinxiaxian from xiaoshoudanbiao))');
showmessage(datamodule100.Query2.SQL.Text);
datamodule100.query2.open;
打开时报错;
报huopinshuliang,huopinshuliang错
WHERE
huopinshuliang>(SELECT MAX(huopinshangxian) FROM xiaoshoudanbiao) OR
huopinshuliang>(SELECT MAX(huopinxiaxian) FROM xiaoshoudanbiao)
datamodule100.query2.sql.Clear;
datamodule100.query2.sql.add('select * from xiaoshoudanbiao where (huopinshuliang>(select top 1 huopinshangxian from xiaoshoudanbiao)) or (huopinshuliang>(select top 1 huopinxiaxian from xiaoshoudanbiao))');
showmessage(datamodule100.Query2.SQL.Text);
datamodule100.query2.open;这样试试!
WHERE
huopinshuliang>(SELECT MAX(huopinshangxian) FROM xiaoshoudanbiao) OR
huopinshuliang>(SELECT MAX(huopinxiaxian) FROM xiaoshoudanbiao)
WHERE A.主键ID = B.主键ID AND (A.huopinshuliang> B.huopinshangxian OR
A.huopinshuliang>B.huopinxiaxian)