On Thu, Jun 17, 2004 at 22:22:34 +0300,
InterZone <[EMAIL PROTECTED]> wrote:
>
> Thanks
> the query you sent failed on v. 7.4, so I added an "end" to the case
> statement. I selected from the tables and the results seem to be correct.
That was an unintentional typo.
>
> I rewrite it for arch
Bruno Wolff III wrote:
On Thu, Jun 17, 2004 at 14:46:08 +,
Interzone <[EMAIL PROTECTED]> wrote:
I want to create a view that will have:
from table t0 the elements "code", "address" and "mun"
from table t1 the elements "code" and "pname"
from table t2 the total number of elements, and the tot
Richard Huxton wrote:
Interzone wrote:
Hi all,
I'm trying to create a view for a client, but I'm failing miserably so
I thought I'ld ask for some help. The initial analysis was quite
complicated, and that specific need never came up until recently, and
unfortunately, changing the tables is prob
On Thu, Jun 17, 2004 at 14:46:08 +,
Interzone <[EMAIL PROTECTED]> wrote:
> I want to create a view that will have:
> from table t0 the elements "code", "address" and "mun"
> from table t1 the elements "code" and "pname"
> from table t2 the total number of elements, and the total number of
>
Interzone wrote:
Hi all,
I'm trying to create a view for a client, but I'm failing miserably so I
thought I'ld ask for some help. The initial analysis was quite
complicated, and that specific need never came up until recently, and
unfortunately, changing the tables is probably not an option :(
Hi all,
I'm trying to create a view for a client, but I'm failing miserably so I
thought I'ld ask for some help. The initial analysis was quite
complicated, and that specific need never came up until recently, and
unfortunately, changing the tables is probably not an option :(
Given the tables
