sgnerd@yahoo.com.sg says...
> (SELECT * FROM history WHERE obs_type = \'AA\' )
> UNION
> (SELECT * FROM history WHERE obs_type = \'TA\');
Maybe I'm just confused here, but what's to stop you using
SELECT * FROM History WHERE (Obs_Type = \'AA\' AND Obs_Type = \'TA\')
? Or have I missed something really obvious?
Paul...
--
plinehan__AT__yahoo__DOT__com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.