Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Inner/outer join
Nevermind... I solved it by counting the number of instances of PageId form each CountryCode. If a PageId does not exist for a specific CountryCode then the result is ZERO. SELECT pid AS PAGE, (SELECT COUNT(*) FROM wa_pagecontent WHERE pid =... -
Inner/outer join
In this thread: Query Help: records in table X but not in Y. http://www.tek-tips.com/viewthread.cfm?qid=942543&page=1 ...there´s a query that gives you "X.ITEM's not in Y". I want a result that gives me "X.ITEM _NOT_ IN Y" as well ass "X.ITEM IN Y". If "X.ITEM _NOT_ IN Y" then I want NULL in... -
Inner/outer join
Well, to clarify, the statement in my last thread gives me a result where only those cases where pid exists for both "se" and "de" are included. What I want is a complete list for countrycode = "se" and "de". If a pid is missing from "de" the the result should be NULL, or something. Can anyone... -
Inner/outer join
I have a table with (amongst others) the columns "pid" and "countrycode" (char and varchar). Pid stands for "PageId". I want a recordset that includes the pid for the countrycode "se" and also includes the pid for the cuntrycodes "de" and "eu", if there are any pid:s for these countries. If a...
