[ovs-discuss] Select operation involving multiple tables

[Ben Pfaff]

On Fri, Jul 04, 2014 at 06:50:27AM +0000, Kamat, Maruti Haridas wrote:
>   I am trying to write a select query on a table which depends upon the outcome of select query on some other table in OVSDB.
> 
> e.g.,
> 
> If I have a table "T1" with  column "COL1", and another table "T2" with columns "COL2" and "NAME". COL1 and COL2 are similar type columns.
> 
> In SQL form, equivalent query is:
> 
> select * from T1 where COL1 in (select COL2 from T2 where NAME = 'ABCD')
> 
> Is there a way to do this in jsonrpc of OVSDB? Or I have to send separate requests to the OVSDB server?

OVSDB doesn't directly support that.

Most OVSDB clients just use a "monitor" replicate the tables they need,
then perform queries on the local replica.