MySQL COUNT 2 QUERIES example

SELECT SUM(CM+CN) FROM    
   (SELECT COUNT(Email) AS CM FROM
      (SELECT Email 
       FROM supplier_company WHERE Email<>'') AS X) AS XX
   ,
   (SELECT COUNT(Email) AS CN FROM
       (SELECT Email 
        FROM supplier_contact WHERE Email<>'' AND Email NOT IN
           (SELECT Email 
            FROM supplier_company WHERE Email<>'')) AS Y) AS YY;

Comments

Post a Comment

Popular posts from this blog

CPanel - WHM - change sending email via server to email Relay (email supplier SMTP) (mailgun)

Following this article https://www.smtp2go.com/setupguide/exim_whm_cpanel/ While choosing mailgun as my supplier, and the help of one of GNS experts, here is what you need to do.  NOTICE this is for SMTP. Open your WHM, in the left search for "Exim" and click "Exim Configuration Manager". Within the new window opened there are some tabs, choose "Advanced Editor". Its Highly recommended that you save the old values for each place you make a change. 1. Find the area under begin authenticators Section: AUTH   and paste these values: mailgun_login:  driver = plaintext  public_name = LOGIN  hide client_send = : postmaster@mydomain.co.il:9b7. ...e3 change the last line to your email account name and your password 2. Find the area under Section: ROUTERSTART and paste these values: mailgun:  driver = manualroute  domains = ! +local_domains  transport = mailgun_transport  route_list = "* smtp.eu.mailgun.org::587 byname"  host_find_failed = defer ...
Read more

OverTheWire[.com] Bandit Walkthrough - JUST HINT, NO SPOILERS

overthewire bandit walkthrough - JUST HINT, NO SPOILERS, just all the hints you need. I made this walkthrough for people like me, i needed some help here and there, but didnt want the spoiler, and even some blogs like  https://www.yalpski.net/  (mentioned with appreciation) that have the solution collapsed, there is no help if i dont know what to do, just need some pointers. so lets go game portal is http://overthewire.org/wargames/bandit/ Bandit The bandit  game is mostly introduction to ssh, bash shell and their tricks Pre Level 0: Connect to SSH If you use linux, your command is " ssh " and thats it. For windows you'll need to download a software, it's in the Level 0 hints  (wikihow) eventually you need to learn more about the ssh command, but the basic is that connection is defined as " ssh <user>@<domain> -p <port> " CTRL+C to break process, CTRL+D to exit from current user's shell I wrote this one down since i co...
Read more

JS Link Tutorial, Sharepoint 2013

Image
there are many suppose to be tutorial about JSLink, but none start form the beginning some history  http://bresleveloper.blogspot.co.il/p/evolution.html basically JSLink is the cliend side way of data-binding and rendering you sharepoint things to ... well it can be sharepoint lists and libraries and it can be your pages. it works like this, the moment you put a url to your js file the item / field / webpart sends all of its data to the client and run your js so what do we have? well best putted is this image from this blog: http://www.codeproject.com/Articles/620110/SharePoint-Client-Side-Rendering-List-Views this means that each part you see here is actually a JS function that accepts the context with all the data and returns some HTML ( function () {     var overrideCtx = {};     overrideCtx.Templates = {};     overrideCtx.Templates.Header = HeaderOverrideFun;     overrideCtx.Templates...
Read more