query for retrieving parameters of objects table

Anonymous — Fri, 17 Jul 2009 02:10:06 GMT

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

topic query for retrieving parameters of objects table in Collaboration with other software

query for retrieving parameters of objects table