Given the follow sample data:  CREATE TABLE People(PeopleID int, Name varchar(10)) INSERT INTO People VALUES(1, 'Chris') INSERT INTO People VALUES(2, 'Cliff') INSERT INTO People VALUES(3, 'Heather')  CREATE TABLE Things(ThingID int, ThingName varchar(10)) INSERT INTO Things VALUES(14, 'Bike') INSERT INTO Things VALUES(17, 'Trailer') INSERT INTO Things VALUES(18, 'Boat')  CREATE TABLE PeopleThings(PeopleID int, ThingID int) INSERT INTO PeopleThings VALUES(1, 18) INSERT INTO PeopleThings VALUES(2, 14)   ...and the following query:  SELECT P.Name,      T.ThingName FROM People P     LEFT OUTER JOIN PeopleThings PT ON P.PeopleID = PT.PeopleID     INNER JOIN Things T ON PT.ThingID = T.ThingID   I am wanting to see the following results:  |Name      |ThingName | ----------------------- |Chris     |Boat      | ----------------------- |Cliff     |Bike      | ----------------------- |Heather   |(null)    | -----------------------   I am wanting a list of everyone in the PEOPLE table, and the names of the THINGS they own (or if they own anything).  I know the issue is somewhere in my JOINs, but I'm not understanding/seeing where.  Please help.
I have 3 tables and I have to inner join Table A with Table B but a left outer between Table A and Table C.   Can I combine outer and inner join in the same query? I can nest queries and attain the desired result but I am unable to do both the joins in the same query. It appears that in other SQL languages, the order of joining is important. Is this the case in SQL Server as well?    Ok, here's the scenario.  Consider 3 tables. Table A, Table F, Table D.  I will need the recordset to contain all rows in D irrespective of whether it exists in F (after it's inner joined with A). So, a outer join comes to mind. What I would need is:   First do a inner join between A and F to get a set (this may be a null set) Then do a outer join with the recordset in (1) with D
Prove that, for all positive real numbers $x$, $y$ and $z$, $$4(x + y + z)^3 &gt; 27(x^2y + y^2z + z^2x)$$  I've tried expressing it as a sum of squares, but haven't got anywhere.   Hints are also welcome. If I run a randomForest model, I can then make predictions based on the model.  Is there a way to get a prediction interval of each of the predictions such that I know how "sure" the model is of its answer.  If this is possible is it simply based on the variability of the dependent variable for the whole model or will it have wider and narrower intervals depending on the particular decision tree that was followed for a particular prediction? Using Apex Managed Sharing to share an opportunity Here's the use case. When a lead is converted to an Opportunity, I want to automatically share the opportunity with the previous owner of the lead. This is needed because upon conversion, the opportunity ownership is granted to someone else but the original lead owner needs ongoing access to the opportunity.  So:   A partner submits/creates a lead and is the lead owner Lead is converted to opportunity and internal sales person gains ownership Original partner needs to have view/edit access on this opportunity   I know you can use Apex Managed Sharing to share a custom object, but I'm hitting a wall trying to do this with an opportunity since the fields in OpportunityShare are not writable. The following won't even compile as a result:  List&lt;OpportunityShare&gt; oppShares = new List&lt;OpportunityShare&gt;(); for(Id i : oppIds) {    OpportunityShare os = new OpportunityShare(OpportunityId = i);    os.OpportunityId = i; // *** ERROR - not writable ***    os.OpportunityAccessLevel = 'Read/Write';    os.UserOrGroupId = oppIdToLead.get(i).OwnerId;    os.RowCause = 'Manual Sharing';    oppShares.add(os); }  Database.SaveResult[] result = Database.insert(oppShares, false); Is it safe to delete from C:\Windows\Installer? Are Living Beings Turned Into Horcruxes Suceptible to Age, Disease, or Injury? From the HP books I know that Horcruxes grant a form of immortality. So, it is not possible for someone who created a Horcrux to die from old age or succumb to diseases. I guess the same is true for living beings turned into a Horcrux. But do living Horcruxes age normally? Is it possible to cripple them or sever their limbs, head or something like that, or do they instantly "repair" themselves like inanimate Horcruxes? Are players allowed to pass a penalty kick? I saw a video of Johann Cruyff , isn't that against the rules? How to search based on part of file name in Google Drive I'd like to be able to find all files in my Google drive that contain the string "_INSTRUCTION_" in the file name. Is there a way to do this?  EDIT 1: When I search for "RMA2013", I should get a dropdown with several options. As you can see, there are several Word and .pdf files with the phrase "RMA2013". Still I get no dropdown help:   And even if I click the search button, I get nothing: Comparing Arrays of Objects in JavaScript For some reason I can't boot my system. I get an error akin to Operating System Not Found.   I tried bootrepair, and that didn't work. So then I decided I would just save my personal files, wipe everything, and reinstall.   But in the live session, when I go to the /home directory, my username folder isn't there, instead it goes to the Live CD's desktop and other directories. Is there some other error occurring? Is there a way to recover the files? Template Hierarchy: confused with index.php, front-page.php, home.php I'm really confused with index.php, home.php and front-page.php. In many cases even though I had an index.php, I overwrite it with front-page.php. But recently, I became aware about home.php.   What's the difference between the home.php and index.php? What's the ideal condition to use a home.php than an index.php? What's the ideal condition to use a front-page.php? When I'm using a front-page.php then what specific task an index.php is doing for me then?   I've read the  in Codex. Please don't mix my question with Page Templates, I understand 'em, alHamduLILLAH. I just installed Oracle's Java version 7u7 on my Mac (running OSX Mountain Lion). However, when I run java -version it still displays the old version (6u29).    How do I fix this? Do I even need to fix this? What version will browsers (Firefox) use in this case? And what version will be used when I run Java applications directly?  I've seen  but this doesn't work in my situation (probably because this question is about the JRE and the other question about the JDK). In my case the Java Preferences app only displays Java 6 versions (32 bit and 64 bit).    Update:   which java points to /usr/bin/java /usr/bin/java is a symlink to /System/Library/Frameworks/JavaVM.framework/Versions/Current/Commands/java /System/Library/Frameworks/JavaVM.framework/Versions/ only contains the folder A (awesome version name) - which Current points to. An excited electron loses energy in the form of radiation. The radiation constitutes photons which move at a speed $c$. But is the process of conversion of the energy of the electron into the kinetic energy of the photon instantaneous? Is there a a simple way to visualize this process rather than math? Install Windows 7 with Bootcamp on OS X Yosemite with USB Key I have an iMac (bought in 2011) and I recently upgraded it with Yosemite. I am trying to install Windows 7 on it via Bootcamp.  However, its optical drive does not work, so I chose the USB key solution using the trick of modifying the file info.plist of Bootcamp (type 'usb bootcamp youtube' in google to see a video of this trick).  So I follow the process religiously and end up with the classic and famous boring screen 'No bootable device -- insert boot disk and press any key'.  So I tried to use Unetbootin (  ) to make my USB Key bootable, and tried to boot on it through the screen that appears when you maintain the Option key (Alt button) while starting the mac. Result: I never managed to have my Unetbootin-formatted USB key appear on this screen :(  I read some stuff about reFit (  ) and GParted, but I just don't know how to use them...  If someone managed to install Windows 7 on his/her iMac with Yosemite using a USB Key, please help me understand why I can't see the USB as a boot option. Why did Obi-Wan Kenobi choose that moment to appear to Luke? In The Empire Strikes Back, Luke Skywalker violently escapes from the lair of a wampa ice creature, finds himself in the middle of a life-threatening snowstorm on an inhospitable planet, collapses from cold and fatigue, and will likely be dead in a few minutes. As :     Luke lies face down in the snow, nearly unconscious. Slowly he looks   up and sees Ben Kenobi, barely visible through the blowing snow. It is   hard to tell if Kenobi is real or a hallucination.     Why did Obi-Wan Kenobi choose this moment to appear to Luke and deliver rather important instructions concerning next steps in his Jedi training?  It seems lucky that Luke remembered anything of the encounter at all. He probably thought he was hallucinating. Where are temporary files in Chrome stored? In The Last Jedi:     The Resistance fleet is tracked through hyperspace by the First Order after they make their jump away from their old base.   As soon as the FO ships appear, the Resistance immediately come to the (correct) conclusion as to the tech that was used.  Why would they assume the use of this tech, that they have never encountered before, as opposed to the more common technique of     tracking a ship through the use of a homing beacon. Can I choose to delay my turn in combat? Suppose that $f(z)$ is analytic function in the disk $|z|\le R$ and $A(r)=\max_{|z|=r}Re(z)$ then prove that $r&lt;R$  $$\max_{|z|=r}\left|\frac{f^n(z)}{n!}\right|\le \frac{2^{n+2}R}{(R-r)^{n+1}}\{A(r)+|f(0)|\}$$  MY attempt   Using Cauchy generalized integral formula   $f^{(n)}(z_0)=\frac{n!}{2\pi i}\int _c\frac{f(z)dz}{(z-z_0)^{n+1}}$  then $\max_{|z|=r}\left|\frac{f^n(z)}{n!}\right|=\left|\max_{|z|=r} \frac{1}{2\pi i}\int _c\frac{f(z)dz}{(z-z_0)^{n+1}}\right|$  and i think we can solve by using Borel caratheodory theorem  Let $f(z)$ be holomorphic function on $|z|\le R$ and let $M(r)=\max_{|z|=r}|f(z)|$ and $A(r)=\max_{|z|=r}Re f(z)$ then  for $0&lt;r&lt;R$  $$ M(r)\le \frac{2r}{R-r}A(R)+\frac{R+r}{R-r}|f(0)|$$  from here how to processed ? How do I calculate the date six months from the current date using the datetime Python module? I am using the datetime Python module.  I am looking to calculate the date 6 months from the current date. Could someone give me a little help doing this?  The reason I want to generate a date 6 months from the current date is to produce a review date.  If the user enters data into the system it will have a review date of 6 months from the date they entered the data. I want to clear all previous commands from the history of my server. I used history -c and it seems all things are cleared but when I ssh to the server, all the commands are still there.  How can I clear them permanently?