Hi,

Suppose I have two tables related in one-to-many relation:

User: (Master table)
- id
- name (string)
- docs (collection)

Doc: (Details)
- id
- name (string)
- status (string)
- user (pointer to User)

I want to get all docs for users that have name contains "ar" for example.
SQL must be something like this:

SELECT name, status, User.name FROM Doc, User WHERE User.id = Doc.user_id
AND User.name LIKE "%ar%"

is there any way to get the result of this query?

Thanks
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
witty-interest mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/witty-interest

Reply via email to