> Us an "AS" clause on each result column of the view in order to
> assign the specific name you want to that column.
That works. Many thanks!
Regards, Christian
"Christian Schwarz" <[EMAIL PROTECTED]> wrote:
> Hello!
>
> We're getting a "no such column" SQL error executing conditional select
> statements using this view:
>
> CREATE VIEW ENTF as select ENTF1.new_key, ENTF1.tp_id_start,
> ENTF1.tp_id_ziel, ENTF2.weg_id, ENTF2.weg_rel_nr from ENTF1, ENTF2 w
Hello!
We're getting a "no such column" SQL error executing conditional select
statements using this view:
CREATE VIEW ENTF as select ENTF1.new_key, ENTF1.tp_id_start,
ENTF1.tp_id_ziel, ENTF2.weg_id, ENTF2.weg_rel_nr from ENTF1, ENTF2 where
ENTF1.keyentf2 = ENTF2.keyentf2;
These are the tables t
3 matches
Mail list logo