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!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
--
No comments:
Post a Comment