$ in a query with UDO

[former_member614281]

Hi all,

I'm trying to use a query where I compare two filds from two tables, the thing is the second table is an UDO,

I'm afraid that the syntax is incorrect, here is the query :

SELECT T1.[U_PDR1] FROM OINS T0 , [@GAMME] T1 WHERE T1.[Code] = $T0.[U_Gamme]

the $ is not well placed but in cant seem to make the syntaxe correct with [@GAMME]

Is anyone familiar with using UDO filds comparision in queries ?

Thanks

[kothandaraman_nagarajan]

Hi,

Try this,

SELECT T1.[U_PDR1]

FROM

[dbo].[@GAMME] T1 LEFT OUTER JOIN OINS T0 ON T1.[Code] = T0.[U_Gamme]

Regards,

Nagarajan

[former_member614281]

Thank you