Hi,
i have two tables: invoice and customer
invoice table:
invoice_number,customer_num,company_code,branch
customer:
customer_num,company_code,branch
first i got requirement like , i need to lookup customer_num,company_code,branch (inner join) in customer table and get invoice_number
invoice---------------->tmap ===> invoice_num
customer.|
after that i got another requirement like lookup only comapny_code and customer_number.
after that i got like lookup only customer_number.
i want to use only one job for above 3 different requirements in such a way that we can configure columns?
Thanks in advance
Jaya