Thanks, I figured that would be the answer, but was hoping that I was missing
something obvious.
David
From: Igor Tandetnik
To: sqlite-users@sqlite.org
Sent: Thursday, May 29, 2014 11:58 AM
Subject: Re: [sqlite] Joining different databases
On 5/29/2014
On 5/29/2014 10:42 AM, David Bicking wrote:
How complicated is the join? Could you show a hypothetical SQL statement
you would have used had both tables been in the same database?
Not complicated: Select b.id, b.name, b.otherfields from a inner join b on a.id = b.id where
a.name<>b.name or a
From: Igor Tandetnik
To: sqlite-users@sqlite.org
Sent: Thursday, May 29, 2014 10:34 AM
Subject: Re: [sqlite] Joining different databases
On 5/29/2014 10:26 AM, David Bicking wrote:
>> I have a somewhat large table in an sqlite database and a
On 5/29/2014 10:26 AM, David Bicking wrote:
I have a somewhat large table in an sqlite database and another large table on
an MS SQL Server database (on a slow network). I want to query both tables in
a join.
How complicated is the join? Could you show a hypothetical SQL statement
you would
I have a somewhat large table in an sqlite database and another large table on
an MS SQL Server database (on a slow network). I want to query both tables in
a join.
The join is likely to produce from zero to a dozen rows.
First thought was to copy the data from the SQL Server table to the sql
5 matches
Mail list logo