Johnstone, Simon wrote: > > $query = "SELECT a.company, b.company FROM tblusers a inner join > tblcompany b on (a.company = b.company) "; > > This works but yet again doesn't print any results to the screen. >
Simon, Try the following to see if you have any trailing spaces in your table select '"' || company || '"' from tblcompany where company like '% '; and select '"' || company || '"' from tblusers where company like '% '; If you have trailing spaces, you might want to cleanup your data by removing them before. The rtrim function is only available in versions of SQLite since 3.5.5. Note the trim() function has been around for a long time. It will trim both trailing and leading spaces. If you don't need to preserve leading spaces, then it should be sufficient to clean up your data. You can check your version with a simple select. select sqlite_version(); HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
