cancel
Showing results for 
Search instead for 
Did you mean: 

$ in a query with UDO

0 Kudos
196

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

View Entire Topic
Johan_Hakkesteegt
Active Contributor
0 Kudos

Hi,

The syntax should probably be something like this:

SELECT T1.[U_PDR1] 
FROM [@GAMME] T1 
LEFT OUTER JOIN OINS T0 ON T1.[Code] = T0.[U_Gamme]

Regards,

Johan

0 Kudos

yes, thank you