>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.