Home > mailing lists

SQL Intersect like problem - Mailing list pgsql-novice

From	Dinesh V
Subject	SQL Intersect like problem
Date	February 4, 2003 23:59:25
Msg-id	HIEKJNDMHAKLHIPCDDOAIENDCCAA.dinesh@trailblazingsolutions.com Whole thread Raw
Responses	Re: SQL Intersect like problem
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Chandralaksana Natalia
Date: 04 February 2003, 23:26:07
Subject: locking granularity

From: Bruno Wolff III
Date: 05 February 2003, 02:03:59
Subject: Re: locking granularity

SQL Intersect like problem - Mailing list pgsql-novice

Previous

Next