James;
> This finds common rows.
Eh!? ... HAVING COUNT(*)=1 returns ONLY pairs that are different:
drop table if exists a,b;
create table a(i int,j int,k int);
insert into a values(1,10,100),(2,20,200),(3,30,300);
create table b select * from a;
update b set k=301 where k=300;
select * from a;
On Feb 11, 2008 7:27 PM, James Eaton <[EMAIL PROTECTED]> wrote:
> SELECT
> MIN(TableName) as TableName, id, col1, col2, col3, ...
> FROM (
> SELECT 'Table a' as TableName, a.id, a.col1, a.col2, a.col3, ...
> FROM a
> UNION ALL
> SELECT 'Table b' as TableName, b.id, b.col1, b.col2, b.col3, ...
From: Peter Brawley
>I'd like to run a query to find the records that
>are present in one database but not the other.
See 'Compare data in two tables' at
http://www.artfulsoftware.com/infotree/queries.php.
Thanks. That's a start.
SELECT
MIN(TableName) as TableName, id, col1, col2, col3,
James
>I'd like to run a query to find the records that
>are present in one database but not the other.
See 'Compare data in two tables' at
http://www.artfulsoftware.com/infotree/queries.php.
PB
James Eaton wrote:
I have two different databases on the same 5.0 server that have the
same tabl
I have two different databases on the same 5.0 server that have the same
tables and structure. They also have very nearly the same data. For one
of the tables I'd like to run a query to find the records that are present
in one database but not the other. Is this possible and what would such a
