Hi, Nick!

I just managed to join 4 tables in the view designer. Yes, the join condition looks weird in the SQL Statamenet generated by view designer, however it works in that form. Usual form (from table join table on... join table on...) is called 'Join to result'. The form used by view designer is called 'join as it is better for performance'.

Well, certain combinations of joins in view designer can cause errors after saving and opening the view again ;(...



>>Hi,
>> I am using View designer to design my view
>> I have 5 tables, I need ot combine then into a view. However it return "SQL Column is not found" even the field is exist in the table. Again, it return "Base table is not match with view" even I don change the structure of base table. Any idea??
>>
>>Thank you
>
>Hi John,
>
>View Designer just doesn't work properly with parallel joins from one table to 2 or more other tables. But you can create such a view programmatically and it will work. Just do not open it then in a View Designer.
>Also you may try Erik Moore's eView from Downloads section