Bring back excluded item

[Sam G]

Hi all,

I have been wrestling with this problem all morning with no success so
far where I have a need to bring back an excluded field.

Basically I have a list of order numbers. Each order number can have
many order types attached one of which is a ‘P’ type. Most order types
have an account number attached in its own field however when a ‘P’ type
is selected the account number is not brought back.

Is there someway I can get this brought back for each P type or do I
have to do some fancy insert in a data warehouse to get this done (i.e.
insert account numbers into all P types)?

Many thanks

Sam


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[David Portas]

Please post DDL (CREATE TABLE statements, including the relevant columns,
keys and constraints) for these tables, post a few rows of sample data as
INSERT statements and show your required result. That way it's much easier
for others to understand and solve your problem.

--
David Portas
------------
Please reply only to the newsgroup
--