Greetings,
I'm new to SQL and SQLite3, I usually create my SQL queries using a query builder and then run it against the SQLite3 engine and tweak it until I get my desired result. I'm trying to join two tables using this statement: SELECT ErrorsText.*, AlertErrors.extra FROM AlertErrors INNER JOIN ErrorsText ON AlertErrors.error = ErrorsText.error WHERE (AlertErrors.id = A) AND (AlertErrors.code = Foo) AND (AlertErrors.subCode = 0) Two rows of data should be returned, I've tried this on other SQL engines like SQL Server Compact and it returns both rows as expected. If I remove the last AND clause the rows are returned as expected, but I must have it because there are times that a subCode may be crucial in retrieving the proper text. I thought that INNER JOIN was completely working in SQLite3, I don't see it mentioned in the docs as one of the joins that is currently being worked on. Is there some kind of error in my SQL statement? Does SQLite3 parse SQL statements different than...say, a Microsoft product would? What query designer do most of you use to create complex queries? Which do you recommend for someone like me? Thanks! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
