cancel
Showing results for 
Search instead for 
Did you mean: 
EN
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

query for retrieving parameters of objects table

Hi,

i wanna query the parameters value and parameters variable name from parameters _of_ objects table.

I cud manage to get it work using the querys as below
select xx.parameters.type,xx.parameters.value,xx.parameters.name from Flat(objects,parameters) as xx where xx.parameters.variable_name='easy_ID' and id='59E19E78-BE54-4D09-8CCC-91A35009DAE8'

Now what i wanna do is instead of using id='59E19E78-BE54-4D09-8CCC-91A35009DAE8', i need to query from other table as
select lb.object_id from objects as ob,labels as lb where ob.id=lb.object_id

when i execute this query alone,it works fine, but i dont know how to insert this query in where clause....... can any1 please help me in this regard????

Thank u
0 Replies 0

Still looking?

Browse more topics

Back to forum

See latest solutions

Accepted solutions

Start a new discussion!