Hi,
When I create a derived table using the following SQL, the derived table prefixes each column in the derived table with the name of the table. The SQL generated in Webi shows the name of the table twice. I am working with a MySQL database with an Infobright engine. BobJ version XI 3.1
The derived table SQL -
SELECT I.PARTY_SK as PARTY_SurrKey, Count(I.STRT_QUOT_EVNT_IND) as start_quot_count
FROM IB_COMM_PARTY_PROD_RLTNP_ETLDEV2 I
where I.STRT_QUOT_EVNT_IND = ‘Y’
group by PARTY_SurrKey
having start_quot_count > 1)
generates the following SQL in WebI -
SELECT
Count(DT_Mult_Strt_Qtes.DT_Mult_Strt_Qtes.PARTY_SurrKey)
FROM
(
SELECT I.PARTY_SK as PARTY_SurrKey, Count(I.STRT_QUOT_EVNT_IND) as start_quot_count
FROM IB_COMM_PARTY_PROD_RLTNP_ETLDEV2 I
where I.STRT_QUOT_EVNT_IND = ‘Y’
group by PARTY_SurrKey
having start_quot_count > 1
) DT_Mult_Strt_Qtes
Has anyone encountered this? How can I resolve this problem?
leighscott (BOB member since 2009-03-27)