Reg:SQL Script Help

[#1]

Hi All,

   I have a following query.My data will be look like this

Table 1

Key	Supply1	Supply2	Supply3	Supply4
Pav12	Source1	Source2
Pav13	Source1	Source2	Source3

]

Table 2

Key	SourceNo	Decvice id
Pav12	1	Dev1
Pav12	2	Dev3
Pav12	3	Dev3
Pav13	1	Qwe1
Pav13	2	Qwe12
Pav13	3	Qwe14
And based on above tables my oputput data should be look like this Key   SourceNo   Pav12   1   Pav12   2   Pav13   1   Pav13   2   Pav13   3

.For Pav12 key the first table having  value only on Source 1 and Source 2 so from table second  I need to take sourceNo of 1 and 2 only,even though its having source no 3

So based on Supply fields from table first I need to show the corresponding source Number. Since the qvw directly connected with Oracle database (No qvd

suggest me in either SQL Script or Load statment to achive it.

-Jai

[rbecher]

Hi Jai,

have you tried this?

- Ralf

[#3]

Hi Ralf,

        Applogies for late reply.And thanks a lot for your reply.It was done in diffrent way. We have achieved by creating key field with four source fields. And we have linked the same with base table.

-Jai