you should at least provide some information about the repository you use.
jakob
[EMAIL PROTECTED] wrote:
Dear all,
Maybe I wasn't asking my question well because it had not gained a response in about a week. Maybe I am missing something very simple, but I am still pretty new to any kinda OR-mappings and I have nobody who can help but this list. Rather then try to explain the 4 different ways I tried to solve it again, how might people with better understanding. I can not find an answer to this in the mailing lists nor in the docs. If you have a reference, please give me a pointer.
I am trying to get a listing of all of the services ('aservice') that are interested in my particular service (having id 101).
// The query I would like agressively abreviated: SELECT r.msid, r.rtitle, r.brief FROM aservice r, serviceinterest si WHERE ((si.targetmsid = 101) AND (si.interestmsid = r.msid))
// I want a collection of these returned CREATE TABLE aservice ( msid BIGINT(20) NOT NULL, rtitle VARCHAR(70) NOT NULL, brief VARCHAR(255) NULL, PRIMARY KEY(msid), )
// Note a duo key that should not be referenced in whole by aservice: CREATE TABLE serviceinterest ( targetmsid BIGINT(20) UNSIGNED NOT NULL, interestmsid BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY(targetmsid, interestmsid) )
I have been having problems because of foreign keys and how INNER JOIN seems to work with this query.
Thank you if you can. I will gladly post more detailed information or email the code as need be.
JohnE [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
