Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 97F40475CCE for ; Mon, 9 Dec 2002 05:44:09 -0500 (EST) Received: from dmhi.ct.ro (dmhi.ct.ro [193.226.151.66]) by postgresql.org (Postfix) with ESMTP id AEB31475F18 for ; Mon, 9 Dec 2002 05:43:00 -0500 (EST) Received: from [192.168.1.114] (helo=aaa) by dmhi.ct.ro with smtp (Exim 3.03 #1) id 18LLOF-0004vw-00 for pgsql-sql@postgresql.org; Mon, 09 Dec 2002 12:43:55 +0200 Message-ID: <008501c29f6f$74aee380$7201a8c0@aaa> From: "cristi" To: Subject: sql Date: Mon, 9 Dec 2002 12:40:55 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0082_01C29F80.372B2580" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/93 X-Sequence-Number: 10681 This is a multi-part message in MIME format. ------=_NextPart_000_0082_01C29F80.372B2580 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have 3 tables. table_a marca 15145 1455 1333 table_b data 11-01-2002 11-02-2002 table_c marca data 15145 11-01-2002 15145 11-02-2002 1455 11-01-2002 1333 11-01-2002 1333 11-02-2002 After interogation of the tables I need this kind of result: marca data 1455 11-02-2002 (I want to receive the records which are a combitation of fields of table_a= and table_b and that are not in the table_c) How can I do that? Thanks! ------=_NextPart_000_0082_01C29F80.372B2580 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I have 3 tables.

table_a

marca

15145

1455

1333

table_b

data

11-01-2002

11-02-2002

table_c

marca data

15145 11-01-2002<= /DIV>

15145 11-02-2002<= /DIV>

1455 =20 11-01-2002

1333 11-01-2002

1333 =20 11-02-2002

After interogation of the tables I need this kind of result:

marca data

1455 11-02-2002<= /DIV>

(I want to receive the records which are a combitation of fields of ta= ble_a=20 and table_b and that are not in the table_c)

How can I do that?

Thanks!

------=_NextPart_000_0082_01C29F80.372B2580--