Re: [SQL] Optimal query suggestion needed

2004-06-17 Thread InterZone
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&q

Re: [SQL] Optimal query suggestion needed

2004-06-17 Thread InterZone
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, changin

[SQL] Optimal query suggestion needed

2004-06-17 Thread Interzone
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