如何在Column for Complex Query中获取行的值？ [英] How can I get the value of rows in Column for Complex Query?

问题描述

我在下面的查询中获取表名，我想在第二个查询中将这些行值作为列我该怎么做才需要帮助。



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来自PR_BUSINESS_FUNCTION_MASTER，其中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，DEPARTMENT_MASTER.ID =&aryFieldId（i）



现在从上面查询我得到的名字

我有以下查询

SELECT&_

BA_COST_CODE_MST.ID BA_COST_CODE_MST_ID，&_

BA_COST_CODE_MST.COST_CODE COST_CODE&_

来自BA_COST_CODE_MST&_



我得到的代码是上面名字的组合我想在这个查询中显示名字。

任何1可以帮助我。

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.

推荐答案

这篇关于如何在Column for Complex Query中获取行的值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！