MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: correct way to sub select ?
Posted by: Jason Carroll
Date: April 09, 2016 09:28PM

Hi,

I have never created a query like this...

I wish to get all the rows where...

`errors`.`isWebSiteLive` != 'HTTP/1.0 200 OK' AND `errors`.`isWebSiteLive` != 'HTTP/1.1 200 OK' AND `errors`.`isWebSiteLive` != 'HTTP/1.0 301 Moved Permanently' AND `errors`.`isWebSiteLive` != 'HTTP/1.1 301 Moved Permanently'

and then add underneath these results...

`oks`.`isWebSiteLive` = 'HTTP/1.0 200 OK' OR `oks`.`isWebSiteLive` = 'HTTP/1.1 200 OK' OR `oks`.`isWebSiteLive` = 'HTTP/1.0 301 Moved Permanently' OR `oks`.`isWebSiteLive` = 'HTTP/1.1 301 Moved Permanently'

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
correct way to sub select ?
Jason Carroll
April 09, 2016 12:45PM
Re: correct way to append second results to first results.
Jason Carroll
April 09, 2016 12:46PM
Re: correct way to sub select ?
Peter Brawley
April 09, 2016 06:55PM
Re: correct way to sub select ?
Jason Carroll
April 09, 2016 09:28PM
Re: correct way to sub select ?
Peter Brawley
April 10, 2016 12:44AM
Re: correct way to sub select ?
Jason Carroll
April 10, 2016 02:00AM
Re: correct way to sub select ?
Peter Brawley
April 10, 2016 10:42AM
Re: correct way to sub select ?
Jason Carroll
April 10, 2016 02:10PM
Re: correct way to sub select ?
Peter Brawley
April 10, 2016 02:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.