I have below query where I get the table names I want to take these rows values in second query as columns How can I do that need help.
MySql = SELECT BA_COST_CODE_MST_DET.FIELD_ID,BA_COST_CODE_STP_DET.FIELD_TABLE FROM( BA_COST_CODE_MST_DET
LEFT OUTER JOIN BA_COST_CODE_STP_DET ON
BA_COST_CODE_MST_DET.FIELD_NO = BA_COST_CODE_STP_DET.FIELD_NO)
MySql = " SELECT PR_BUSINESS_FUNCTION_MASTER.ID,PR_BUSINESS_FUNCTION_MASTER.BUSINESS_FUNCTION_NAME FROM PR_BUSINESS_FUNCTION_MASTER WHERE PR_BUSINESS_FUNCTION_MASTER.ID = " & aryFieldId(i)
MySql = " SELECT PR_PRODUCT_MASTER.ID , PR_PRODUCT_MASTER.PRODUCT_NAME FROM PR_PRODUCT_MASTER WHERE PR_PRODUCT_MASTER.ID= " & aryFieldId(i)
MySql = " SELECT PR_JOB_FUNCTION_MASTER.ID,PR_JOB_FUNCTION_MASTER.JOB_FUNCTION_NAME FROM PR_JOB_FUNCTION_MASTER WHERE PR_JOB_FUNCTION_MASTER.ID = " & aryFieldId(i)
MySql = " SELECT DEPARTMENT_MASTER.ID,DEPARTMENT_MASTER.NAME FROM DEPARTMENT_MASTER WHERE DEPARTMENT_MASTER.ID = " & aryFieldId(i)
Now from above query I get the names
I have below query
" SELECT " & _
" BA_COST_CODE_MST.ID BA_COST_CODE_MST_ID," & _
" BA_COST_CODE_MST.COST_CODE COST_CODE" & _
" FROM BA_COST_CODE_MST " & _
where I get code which is combination of above names i want to show the names in this query.
Can any 1 help me.