What is the SQL Select Statement for merging 2 sets of results with the same column names?
combining results of two select statements
Pygame - blitting from x and y cordinates of image How to best respond to a request to send a passport scan by unsecured email? It is not uncommon for travel or holiday accommodation companies to ask for a scan of your passport by email. Sometimes local laws require them to keep a record of the passport numbers of all visitors. I'm happy to provide that information but you usually have to send it in an unsecured email, which may have consequences .  Could these companies be more responsible, and provide a public cryptographic key at least?  Are there other steps you should take to protect yourself, if you do send by unsecured email? I'm reading through a proof in my lecture notes:     Every convergent sequence of a metric space has a unique limit.   Suppose $\lim_{n \to \infty} x_n = l$ and $\lim_{n \to \infty} x_n = m.$ Then for every $\epsilon &gt; 0,$ there exists $N$ such that for every $n \geqslant N,$  $$d(l,m) \leqslant d(l,x_n) + d(x_n,m) &lt; \epsilon + \epsilon = 2 \epsilon. $$  So $(\star) \hspace{1mm} 0 \leqslant \frac{d(l,m)}{2} &lt; \epsilon \Longrightarrow \hspace{1mm} (\star^\prime) \hspace{1mm} \frac{d(l,m)}{2} =0 \Longrightarrow l = m.$  I can follow the proof up until the jump from $(\star)$ to $(\star^\prime)$. Why does $\frac{d(l,m)}{2}=0$? How do I rotate an object along it's own axis (windmill) I'm trying to rotate the blades of a windmill for an animation but the windmill is already at an angle. When I keyframe it on it's own axis (after pressing control + alt + space) and rotate it the blades spin inwards during the animation before coming back at the end. I've tried locking the other axis but that keeps the blades from rotating back to the right orientation. Also, whenever I rotate the object 360 degrees it turns the 360 into a really small number (0.0001) so it plays forward hallway then backwards (with a 180 degree keyframe halfway). Any help would be appreciated!. How do I put /home in a different partition? Yeah, so I have 2 hard drives, on with 2 partitions(backups and windows), and I have another that also has 2 partitions with only one used. I have Ubuntu on hard drive 2:partition one, but I have come to a point when the /home folder can't hold any more files, but the partition is only about 15% filled up. So I did some researching and figured out that you can put it on a separate partition, but most of the guides were vague on what I needed to do. Could someone give me step-by-step instructions on what I need to do, or even tell me a, easier or different way to fix this /home folder capacity problem? Significance of starting the Fibonacci sequence with 0, 1.... DISCLAIMER: I do not deal with in-depth mathematics on a daily basis as some of you may, so please pardon my ignorance or lack of coherence on this topic.  QUESTION: What is the significance of starting the Fibonacci sequence with $0,1$ ?  For instance, if I picked any two random integers, say 2 and 7, to start a sequence would I actually be creating some multiple or derivation of the Fibonacci sequence?  Is there a general mathematical explanation for the relationship between any sequence represented by $a[0] = x, a[1] = y, a[n] = a[n-1] + a[n-2]$ and the Fibonacci sequence?  Or, back to my example sequence, is there a general mathematical relationship between:  $2,7,9,16,25,41,66,107,173,280...$  and  $0,1,1,2,3,5,8,13,21,34...$  Perhaps the Golden Ratio explains it somehow?  Any help would be appreciated. Received W-2 but was never paid I just now received a W-2 from a company that I worked for 3 days as a contractor. I had to leave country for 2 months due to a family emergency. Since the employment duration was very short, I was not paid. I was told that they don't want to charge the client because 3 days is not enough contribution.  Since I had to leave country the same day, I did not argue with them and told it's okay if they feel right.  Now I have a W-2 from them saying they have paid me about $1500. I contacted them but I have not received any reply yet.  I just want to be prepared. What can I do here? I have a CSV containing x,y, and z coordinates. The CSV also has a fourth column containing information on sphere diameter. I need to create a sphere at each coordinate, having the corresponding diameter. Can someone provide me a basic Python script that performs this task? My actual task is much more involved, but I think I can solve it if I have the basics in place. Sentient Bomb in a city on the moon? I would like to know the title of the short story that I believe takes place on the moon.  The setting is a mall or some other very public location and the main character is a police officer.  She needs to talk a sentient bomb out of exploding.  I know there was the John Carpenter film "Dark Star" with a similar plot line but I'm trying to identify the short story and the author. InDesign: How do I automatically align the bottoms of different columns of text boxes to the same height as the one with the most text? In InDesign, I have some filled text boxes, sized by columns, with the one on the left being three columns wide.   The wide text box is most likely to contain the most text (it's an invoice template).  I will use the 'Fit frame to content' button on the Selection Tool toolbar for automatically vertically resize it to fit the containing text.  How do I make the other three smaller text frames automatically adjust to the same height as the big (and longer) text box? Question:  Show that $n^2 + 3n + 5$ is not divisible by $121$, where $n$ is an integer. Are token creatures considerd as a creature spell? Jeffrey Wooldridge in his Econometric Analysis of Cross Section and Panel Data (page 357) says that the empirical Hessian "is not guaranteed to be positive definite, or even positive semidefinite, for the particular sample we are working with.".  This seems wrong to me as (numerical problems apart) the Hessian must be positive semidefinite as a result of the definition of the M-estimator as the value of the parameter which minimizes the objective function for the given sample and the well-known fact that at a (local) minimum the Hessian is positive semidefinite.  Is my argument right?  [EDIT: The statement has been removed in the 2nd ed. of the book. See comment.]  BACKGROUND Suppose that $\widehat \theta_N$ is an estimator obtained by minimizing $${1 \over N}\sum_{i=1}^N q(w_i,\theta),$$ where $w_i$ denotes the $i$-th observation.  Let's denote the Hessian of $q$ by $H$, $$H(q,\theta)_{ij}=\frac{\partial^2 q}{\partial \theta_i \partial \theta_j}$$  The asymptotic covariance of $\widehat \theta_n$ involves $E[H(q,\theta_0)]$ where $\theta_0$ is the true parameter value. One way to estimate it is to use the empirical Hesssian  $$\widehat H=\frac{1}{N}\sum_{i=1}^N H(w_i,\widehat \theta_n)$$  It is the definiteness of $\widehat H$ which is in question. ViewExpiredException in Firefox and IE after migrating to Jboss 7.0 AS Problem with camera orientation in motion tracking sorry for my English, I write from Italy. I'll try to explain my problem. I'm tracking a footage with a solver error 0.2973. When I try to set the floor, the orientation of the camera is wrong (see screenshot).  So I tried to manually orient the camera, but even if well oriented respect to the xyz axes, geometry is incorrect as you can see from the screenshots below (the selected marker appears to be on the same plane but it is lower).  The video was recorded by a roof of a house so much higher than the road. It seems that Blender is not able to recognize this height and set the floor in a wrong point of view. Can someone help me solve this problem? Thank you How to Solve this Arithmetic Progression Question? Please help-  Four different integers form an increasing AP.One of these numbers is equal to the sum of the squares of the other three numbers.Then- find all the four numbers.  I assumed the numbers to be $a,a+d,a+2d,a+3d$ and wlog let $a+3d$ this number and according to question-  $a^2+(a+d)^2+(a+2d)^2=a+3d$  but I could not solve the above equation. how to get output of a script/program into a file? Why is there conservation of kinetic energy in elastic collision and not in inelastic collision? Is it possible to perform a power analysis for the Kruskal-Wallis and Mann-Whitney U test? If yes, are there any R packages/functions that perform it? What computer components are currently vulnerable to magnets? When I first started using computers, law of the land in computer class was never bring magnets near anything computer related, lest you lose all your data or screw up your monitor.  Now I am pretty sure magnets will still royally mess up a standard hard drive, and I know for a fact they screw up a CRT monitor.  Though I am also pretty sure they do not screw up a LCD monitor?  Now I have my phone which uses magnets to determine if it's docked, and it made me wonder.  Is it the power of the magnet preventing data loss or the sheer fact that whatever memory type in the phone is immune to it?  What about ear buds, as I know those have tiny magnets in them. Are those capable of damaging any electronic device currently in use?  I'm wondering if I'm being paranoid, but I really am not sure what magnets will damage and what they won't!  Is there a list, or rule of thumb for determining what will be hurt by magnets and what won't be?