Received: from falla.videotron.net (falla.videotron.net [205.151.222.106]) by hub.org (8.10.1/8.10.1) with ESMTP id e6SKvCB09158 for ; Fri, 28 Jul 2000 16:57:12 -0400 (EDT) Received: from inter-resa.com ([24.201.29.185]) by falla.videotron.net (Sun Internet Mail Server sims.3.5.1999.12.14.10.29.p8) with ESMTP id <0FYF00GC5E4Q7L@falla.videotron.net> for pgsql-sql@postgresql.org; Fri, 28 Jul 2000 16:55:38 -0400 (EDT) Date: Fri, 28 Jul 2000 16:54:58 -0400 From: Web Manager Subject: two table comparison: find a mismatch? To: pgsql-sql@postgresql.org Message-id: <3981F322.1CFE9A47@inter-resa.com> Organization: INTER-Res@ tourism network MIME-version: 1.0 X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.12 i386) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en X-Archive-Number: 200007/275 Hello, here is to table: Table "city" Attribute | Type | Modifier ----------------+-------------+--------------------------------------------- city_id | smallint | not null default nextval('seq_city'::text) region_id | smallint | region_tour_id | smallint | country_id | smallint | name_fr | varchar(40) | name | varchar(40) | url_id | smallint | Table "region" Attribute | Type | Modifier -----------+-------------+---------------------------------------------- region_id | smallint | not null default nextval('seq_region'::text) country_id| smallint | name_fr | varchar(40) | name | varchar(40) | address | boolean | url_id | smallint | I whant to fins a "hole" in the linkage... a region number in the city table is not in the region table any more. How can I do that? Where is the city.region_id <> region.region_id Thanks! -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Marc Andre Paquin