[Gambas-user] Whats wrong with my SQLITE3 expression?

This is my first attempt at using INNER JOIN. SELECT properties.*, tenants.* FROM properties INNER JOIN tenants ON properties.PropertyID = tenants.PropertyID Can anyone advise? -- View this message in context:

Re: [Gambas-user] Whats wrong with my SQLITE3 expression?

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