to retrieve customer name and customer num [message #591114] |
Wed, 24 July 2013 21:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/90234a275f10aa55b4ee75fa55189666?s=64&d=mm&r=g) |
narrasai27
Messages: 2 Registered: July 2013 Location: kuala lumpur
|
Junior Member |
|
|
Hi friends,
i need to get the customer name and customer number based on certain condition
in the table oe_transaction_types there is a column transaction_type and attribute1
now i need to retrieve the filter the customers with the combination of transaction_type and attribute1.
for example in " oe_transaction_types "
transaction_type attribute1
--------------- --------------
xyx
xyz con
xyz con
xy2
abc mnv
so now i have to get the customername and customer num whos transaction_type and attribute1 is not null that means only 3 customers from the above example.
so now pls give the query for this requirement to get the customer name and cust num.
Thanks and Rgrds
(Sai Kishore)
|
|
|
|
|
|