Re: Looking for ORACLE/Sql Forms 3.0 help

Maybe this will do it:-

	where	(mytable.field3 IS NOT NULL	and
		 mytable.field1 = :input.field1	and
		 mytable.field2 = :input.field2	and
		 mytable.field3 = :input.field3)
	or
		(mytable.field3 IS NULL		and
		 mytable.field1 = :input.field1	and
		 mytable.field2 = :input.field2)
	
	ORDER by field4
-- 
Richard Thombs					      Lucas Powertrain Systems,
Mail:  rst_at_eg.lucasauto.co.uk			      Phoenix Way,
Phone: +44 285 657981 x233			      Cirencester, GL7 1QG,
Fax:   +44 285 658258 (G3)			      England.