How do we nest queries? Trying to do an update. Have two types of documents, zip codes and states. There are two fields in particular in the zip code document: "state_id" (String) and "state" (Link). Would like to add SELECT the "id" field in the state documents and insert the RID if it matches.
I would have thought something like: UPDATE Zipcodes SET state=(SELECT @rid FROM States WHERE id=Zipcodes.state_id); Where Zipcodes.state_id is a field in Zipcodes and would match the field, States.id. It would then select the RID in States and insert it in the ZIpcodes.state field (Link). In MySQL examples are here: http://dev.mysql.com/doc/refman/5.0/en/subqueries.html How is this done in OrientDB? Saw something with the LET command but doesn't seem to work with updates. Thanks! -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
