General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Have a database container with 8 tables. Trying to create a view using three tables. The Tables are related properly. Get the SQL: Column Fieldname error, but the fieldname exists in all the tables. What's going on? (using inner joins).
Check the result cursor. Sometimes when you have fields with the same name you will get fields like field_a, field_b. SQL is trying to resolve the naming conflict.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only