Ah yes, you are correct. It was my typo. Works perfectly.
On 5/22/14, RSmith [via SQLite] <ml-node+s1065341n75787...@n5.nabble.com> wrote: > > > I'm trying to understand the grouping magic and testing the first and > last query. > Only thing is for some reason, I'm not getting any result for the last > query. Perhaps i'm doing something wrong. > > > Works perfectly for me, are you sure you have it exactly so? Check the table > names correspond to your tables maybe. (Though the > other queries should fail too if that was a problem): > Also ensure you have a Person in the PersonTable with id = 5. > > SELECT T.id AS TeamID, T.name AS TeamName, P.id AS PersonID, P.name AS > PersonName > FROM TeamPersonTable TP > LEFT JOIN PersonTable P ON P.id=TP.personId > LEFT JOIN TeamTable T ON T.id=TP.teamId > WHERE P.id=5 > > > > On 2014/05/22 14:28, Humblebee wrote: >> Wow, I just tried the "Group" thing and it's truly magic. Big Bang ! >> The first query gave the Exact answer I was looking for. It even >> assembled a string. > > Forgot to mention: These queries and subsequent amazement is only courtesy > of those tables being in 1NF format now, it is what makes > the queries possible to be linked up in the way (or in any other way you > might dream up) - which is why other posters tried to urge > you so hard to consider changing to this. Very glad you did. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > If you reply to this email, your message will be added to the discussion > below: > http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75787.html > > To unsubscribe from Simple Select from IN - from a newbie., visit > http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=75751&code=ZmFudGFzaWEuZG9zYUBnbWFpbC5jb218NzU3NTF8MTk4Njk4NTgwNw== -- View this message in context: http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75788.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
