SQL Intersect like problem

From: "Dinesh V" <dinesh(at)trailblazingsolutions(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: SQL Intersect like problem
Date: 2003-02-05 02:00:47
Message-ID: HIEKJNDMHAKLHIPCDDOAIENDCCAA.dinesh@trailblazingsolutions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello Folks,

I have 7.3.1 running, and have an interesting SQL problem, please help.
Consider an Invoice Table with columns

InvoiceId
ProductId
Quantity

Given a set of ProductId and Quantity, I need to find the InvoiceId that
correspond to it. I can create a temp table with these 2 columns (ProductId
and Quantity) if necessary.

I would appreciate any help in this regard.

Thanks,
Dinesh

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-02-05 04:17:05 Re: locking granularity
Previous Message Chandralaksana Natalia 2003-02-05 01:26:09 locking granularity