Bugs item #1979819, was opened at 2008-05-31 00:06 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1979819&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: MonetDB5 CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: LEFT JOIN combined with same table Initial Comment: I have three tables: Usernames, Relations, Relation_tags First; I want to lookup all Relations having Relation_tags with k='type' and v='way' After this I want to do a left join, on relation_tags getting the other values of Relation_tags with that are semantically linked to Relations; select relations.id, relations.visible, usernames.username, '2007-09-07T16:39:10+01:00' FROM relations, usernames, relation_tags AS constr WHERE relations.username = usernames.id AND constr.k='type' AND constr.v='way'; Works. Adding the LEFT JOIN; select relations.id, relations.visible, usernames.username, '2007-09-07T16:39:10+01:00' FROM relations, usernames, relation_tags AS constr LEFT JOIN relation_tags AS joiner ON relations.id = joiner.relation WHERE relations.username = usernames.id AND constr.k='type' AND constr.v='way'; !SELECT: no such column 'relations.id' No such column? Isn't that strange? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1979819&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
