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]
