Hello, Using sqlite3, I entered this create view statement: CREATE VIEW IF NOT EXISTS "Annies Form" AS SELECT Categories.Category_Name, Strings.Long_Text, Units.Long_Units, Limits.Lower_Limit, Limits.Upper_Limit FROM ((((Objects INNER JOIN (Categories INNER JOIN Object_Categories ON Categories.Category_ID=Object_Categories.Category_ID) ON Objects.Object_ID=Object_Categories.Object_ID) INNER JOIN Units ON Objects.Unit_ID=Units.Unit_ID) INNER JOIN Strings ON Objects.String_ID=Strings.String_ID) INNER JOIN Addresses ON Objects.Address_ID=Addresses.Address_ID) INNER JOIN Limits ON Objects.Limit_ID=Limits.Limit_ID WHERE (((Categories.Category_Type_ID)=1));
sqlite3 complains that the column Categories.Category_Name does not exists. Yet, I can do a Select Categories.Category_Name From Categories with no problems. This create view worked as well: CREATE VIEW IF NOT EXISTS 'Select_Categories' AS SELECT Categories.Category_ID, Categories.Category_Name, Strings.Long_Text, Strings.Short_Text, Strings.Alternate_Text, Category_Types.Category_Type FROM (Categories INNER JOIN Strings ON Categories.String_ID = Strings.String_ID) INNER JOIN Category_Types ON Categories.Category_Type_ID = Category_Types.Category_Type_ID; As a side note, these were predefined queryDefs from an MS Access db that, I believe, work OK. Vance _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
