multi table query

32 views
Skip to first unread message

Vishnu Tammi

unread,
Dec 3, 2014, 2:03:16 PM12/3/14
to orient-...@googlegroups.com
Does orient db supports multi table queries like sql. when I tried this query is showing query executed  but zero results were shown.
select P_NAME FROM part where part.P_PARTKEY=Partsupp.PS_PARTKEY;
where part and partsupp are my class names and P_NAME,PS_NAME are attributes of the respective classes.
please tell me how to do querying in orientdb.

Luca Garulli

unread,
Dec 3, 2014, 2:07:46 PM12/3/14
to orient-database
You should rather use LINKS or EDGES between your records to connect them. How is your database? Could you share it with us?

Lvc@


--

---
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 orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Vishnu Tammi

unread,
Dec 3, 2014, 5:45:10 PM12/3/14
to orient-...@googlegroups.com
I have shared my database in github. I have also created links between the classes by using CREATE LINK COMMAND .the query executed. but when I try to use multi table query like 
select P_NAME FROM part where part.P_PARTKEY=Partsupp.PS_PARTKEY;
where part and partsupp are my class names and P_NAME,PS_NAME are attributes of the respective classes.
please tell me how to do querying in orientdb.
 when I tried this query is showing query executed  but zero results were shown.
 I don't understand why it is not showing results.


--

---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/eOsFVg2u5Vg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.

Curtis Mosters

unread,
Dec 4, 2014, 2:50:49 AM12/4/14
to orient-...@googlegroups.com
I cannot find a link to the database =/
Reply all
Reply to author
Forward
0 new messages