sql

From: "cristi" <cristi(at)dmhi(dot)ct(dot)ro>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: sql
Date: 2002-12-09 10:40:55
Message-ID: 008501c29f6f$74aee380$7201a8c0@aaa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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!

Responses

  • Re: sql at 2002-12-09 12:04:59 from Richard Huxton

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2002-12-09 12:04:59 Re: sql
Previous Message Michael Weaver 2002-12-09 06:51:24 Default Permissions (repost from Novice)