Re: VIEWS - Need Help
From: <e_humblot_at_wanadoo.fr>
Date: Thu, 23 Jul 1998 21:28:10 +0200
Message-ID: <6p83ir$mp7$1_at_platane.wanadoo.fr>
Date: Thu, 23 Jul 1998 21:28:10 +0200
Message-ID: <6p83ir$mp7$1_at_platane.wanadoo.fr>
Create or replace VIEW name AS
select
...
from
...
where
...
and IN_stat_cd = 'COM'
union
select
...
from
...
where
...
and IN_stat_cd != 'COM'
Received on Thu Jul 23 1998 - 21:28:10 CEST