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
the current release of sqlite, as does the "inner join"
syntax.
- Jeff
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Johnstone, Simon
Sent: Monday, February 11, 2008 11:44 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Join troub
2008 16:17
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Join trouble
Simon,
If the query is returning no rows, my guess would be trailing spaces in
the data. This has been discussed at length and there is a new collating
sequence (http://www.sqlite.org/cvstrac/chngview?cn=4732)
Did you try with an inner join with table aliases?
so:
from tblusers a inner join tblcompany b on
(a.company = b.company)
RBS
> I am having serious trouble creating a join on my database. I have
> tested it in other databases and it works so it must be a problem with
> sqlite and the join??? I
(tblcompany.company)
- Jeff
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Johnstone, Simon
Sent: Monday, February 11, 2008 11:11 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Join trouble
I am having serious trouble creating a join on my database. I have
5 matches
Mail list logo