________________________________
From: Igor Tandetnik <i...@tandetnik.org>
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 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 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.otherfields<>b.otherfields; -- where
"otherfields" is about four fields of information.
David
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
