Re: [sqlite] JOIN Error!!!

On 7/7/06, Roger <[EMAIL PROTECTED]> wrote: Can anyone help me out here, i am a bit stuck and this is a very strange error indeed! Having a copy of your database might help if you can post it.

Re: [sqlite] JOIN Error!!!

On 7/7/06, Roger <[EMAIL PROTECTED]> wrote: I have the following query CREATE VIEW MyStuff AS SELECT Com . CompanyID CompID , PublicationID PubID , Your SQL looks very confused. Are there really spaces around the period here or is that just in this message? Spaces are important for the engine

[sqlite] JOIN Error!!!

I have the following query CREATE VIEW MyStuff AS SELECT Com . CompanyID CompID , PublicationID PubID , RelationshipDescription Relationship , CompanyName Name , BranchName Branch , BranchID FROM Publication_Branch_Relationships AS PBRel LEFT JOIN ltblPublication_Branch_Relationship AS BRel ON P