Subject | SQL headache |
---|---|
Author | Nick Upson |
Post date | 2005-06-27T10:16:53Z |
I'm having real trouble coming up with an SQL statement or SP to achieve
this:
I have 2 tables, SalesOrder (SO) and salesorderline (SOL). Given a SO
reference (unique key to SO table) I need to locate any other Sales orders
with the same combination of orderlines regardless of quantity
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
this:
I have 2 tables, SalesOrder (SO) and salesorderline (SOL). Given a SO
reference (unique key to SO table) I need to locate any other Sales orders
with the same combination of orderlines regardless of quantity
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly