Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!uunet!mcsun!sunic!tut!tukki!jukka
From: jukka@tukki.jyu.fi (Jukka Hartikainen)
Newsgroups: comp.databases
Subject: Tricks & INGRES Report-Writer
Message-ID: <2917@tukki.jyu.fi>
Date: 2 Feb 90 14:11:00 GMT
Reply-To: jukka@tukki.jyu.fi (Jukka Hartikainen)
Organization: University of Jyvaskyla, Finland
Lines: 21

I have a little problem in doing SELECT-clause in
Ingres Report-Writer. I know that there is no way
to do it "pure", but some other way maybe...

If I have

  SELECT  ...., constant=value, ...
  FROM    ...
  WHERE (condition 1) or (condition 2)

and I'd like to get the value of constant 1 or 2 depending of
which one of the where-conditions is true. Is it possible and how?

The main idea is that the constant is one sort column and in the
report there will be header and footer for that. The data is
some personal records and depending of in what group one person is,
his/hers data is in right place.

Thanks!

---Jukka