I just tried the same syntax with two new tables each with the same primary key, INNER JOIN worked OK.
In my original post, properties.PropertyID is a primary key (integer) and tenants.PropertyID is integer but not a primary key. This seems to the problem. Any further ideas? -- View this message in context: http://old.nabble.com/Whats-wrong-with-my-SQLITE3-expression--tp26193279p26194183.html Sent from the gambas-user mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user