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