AW: [sqlite] Views over multiple tables and conditional selection (ticket #1134)

> 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

[sqlite] Views over multiple tables and conditional selection (ticket #1134)

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