Re: Function in selection?

On Thu, 2003-03-13 at 20:11, Jean-Luc Lachance wrote:
Z is row from TABLE_Y and should be read on the fly...

> How is Z being joined?  What's the condition?
> 
> 
> "Dousak May (Phoebus Apollonus)" wrote:
> > 
> > Hi, I want to make really advanced query and I'm not sure it's
> > possible... it would be "like that":
> > 
> > select A, B, C, D, E, F from TABLE_X ORDER BY D, C, E
> >   if A==0 AND B!=0 {A=B*Z.TABLE_Y}
> >   if A!=0 AND B==0 {B=A/Z.TABLE_Y}
> > 
> > OK, I don't really have problems with first line :), but how can I tell
> > him to select like the second and third line are telling it?
> > is that possible? :/
> > 
> > Tnx,
> > 
> > May