Hi Everyone,

Can anyone pls help me out......with my requirement, i am struggling since 3 days. Please find the requirement below

my file contains below data


Code:
R1|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.10.00.20|8533.10.00.20|
R1|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|CARBON*||8533.10.00.20|8533.10.00.20|
R4|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|THROUGH HOLE MOUNT|AND|8533.10.00.57|8533.10.00.57|
R4|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|CARBON*||8533.10.00.57|8533.10.00.57|
R7|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.21.00.10|8533.21.00.25|
R7|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|!CARBON*|AND|8533.21.00.10|8533.21.00.25|
R7|Array/Network Resistor - VIP|V_PRT_CLASS|V_MFR_PKG_DESC|DIP*||8533.21.00.10|8533.21.00.25|


i need a perl script to generate single sql statement for the unique column 1 attribute as below

select a.V_MOUNT_FEATURE, b.V_TECHNOLOGY, c.V_MFR_PKG_DESC from V_RES_CLASS a, V_RES_NW_CLASS b, V_PRT_CLASS c where a.V_MOUNT_FEATURE='SURFACE MOUNT' and b.V_TECHNOLOGY not like 'CARBON%' and c.V_MFR_PKG_DESC like 'DIP%';

Please help me out.

Hello jam2010, welcome to the forum!

Could you show us what you have tried so far? We might be able to help you get it to work, but I don't know that anyone here will write a script to spec from scratch.

Thanks!
-G