SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' AND IQ > 80
===== Execute
===== No Rows Returned
You could join them (they aren't really separate tables) using subqueries like this to return their respective rows as separate virtual tables:
SELECT * FROM ( SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' ) as P FULL OUTER JOIN ( SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge' ) as S
But unless they share a common key or attribute on which to join, you will just get a cartesian product -- AND NOBODY wants a cartesian product of PurpleJ or Splooge, so it would be best to use a union to just show their rows as follows:
INSERT INTO HardcoreHusky.Junk
SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' UNION ALL SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge'
Leave off the INSERT clause if you actually want to see the rows instead of putting them where they belong.
Accuracy depends on what data you want. Again, is there a key or attribute in the table that joins Purp to Splooge? If not, then there is nothing to join, which is when you'd use the union instead.
SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' AND IQ > 80
===== Execute
===== No Rows Returned
You could join them (they aren't really separate tables) using subqueries like this to return their respective rows as separate virtual tables:
SELECT * FROM ( SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' ) as P FULL OUTER JOIN ( SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge' ) as S
But unless they share a common key or attribute on which to join, you will just get a cartesian product -- AND NOBODY wants a cartesian product of PurpleJ or Splooge, so it would be best to use a union to just show their rows as follows:
INSERT INTO HardcoreHusky.Junk
SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' UNION ALL SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge'
Leave off the INSERT clause if you actually want to see the rows instead of putting them where they belong.
Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
"Shkreli, who is currently awaiting trial for securities fraud, said later that “all you people who don't like trump are jealous, stupid and poor! don't make me laugh!” "
Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
Small beans compared to the Clinton Foundation, but interesting none-the-less...
Interesting?
Maybe if you're a faggot.
Maybe if you are a faggot ????. Another 8th grade level intellect on display. Care to offer an interesting insightful rebuttal. I bet thats to much to ask .
Where the fuck do you think you are, Texan?
Hahaha, oh good lord this is getting good. Lets see. I am setting at my desk running test on a MySql database 34 miles north of Austin Texas. And where are you ? Has 8th grade started in Washington state yet? Still out for summer break ?.
MySql?
CHRIST.
So you must be a Dbase III guy.
SQL Server is what companies with money typically use.
Actually, companies with money that know what they are doing tend to use Oracle or Teradata or Netteza or DB2, etc.
SQL Server is for companies with money that don't know what they are doing and so some MSFT consultant points them at SQL Server.
Source: I was a SQL Server dev at MSFT for 8 years, and have been doing SQL on various platforms for 20 years.
Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
"Shkreli, who is currently awaiting trial for securities fraud, said later that “all you people who don't like trump are jealous, stupid and poor! don't make me laugh!” "
I'm sorry...I missed the part where Shkreli is related to a Republican in office or where Shkreli and his company donated large sums of money to Trump's "charity" and lobbied him soon after for favors while he was in a public office.
Keep trying and keep lapping up Clinton like you do...
I thought OZONE was a seaplane pilot, not a computer nerd?
Being a SQL & system pro pays really well, and I've been doing it for 20+ years. How do you think I can afford to continue repairing all my crashed flying boats.
Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
"Shkreli, who is currently awaiting trial for securities fraud, said later that “all you people who don't like trump are jealous, stupid and poor! don't make me laugh!” "
I'm sorry...I missed the part where Shkreli is related to a Republican in office or where Shkreli and his company donated large sums of money to Trump's "charity" and lobbied him soon after for favors while he was in a public office.
Keep trying and keep lapping up Clinton like you do...
I thought you guys like the freedom to lobby in our great nation? Are you asking for greater regulation now?
Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
"Shkreli, who is currently awaiting trial for securities fraud, said later that “all you people who don't like trump are jealous, stupid and poor! don't make me laugh!” "
I'm sorry...I missed the part where Shkreli is related to a Republican in office or where Shkreli and his company donated large sums of money to Trump's "charity" and lobbied him soon after for favors while he was in a public office.
Keep trying and keep lapping up Clinton like you do...
I thought you guys like the freedom to lobby in our great nation? Are you asking for greater regulation now?
So all lobbyist have equal access kinda like all capitalism is the same. Cute hiding behind the regulation/deregulation thing. You'd be scream like a little bitch if the R's were in control. What you have been advocating is cronyism and yeah its wrong when the R's are in power but I guess merit, efficiency, etc are old antiquated ideas too. Whats also funny is you think you are a member of the lefty elite, that 1%. Yet you live on a message board when you are not crashing floatplanes. What happens when you are pink slipped from that DBA job and replaced by a kid from Bangalore for half the wages
Accuracy depends on what data you want. Again, is there a key or attribute in the table that joins Purp to Splooge? If not, then there is nothing to join, which is when you'd use the union instead.
SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' AND IQ > 80
===== Execute
===== No Rows Returned
You could join them (they aren't really separate tables) using subqueries like this to return their respective rows as separate virtual tables:
SELECT * FROM ( SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' ) as P FULL OUTER JOIN ( SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge' ) as S
But unless they share a common key or attribute on which to join, you will just get a cartesian product -- AND NOBODY wants a cartesian product of PurpleJ or Splooge, so it would be best to use a union to just show their rows as follows:
INSERT INTO HardcoreHusky.Junk
SELECT * FROM HardcoreHusky.Members WHERE Name = 'PurpleJ' UNION ALL SELECT * FROM HardcoreHusky.Members WHERE Name = 'Splooge'
Leave off the INSERT clause if you actually want to see the rows instead of putting them where they belong.
Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
"Shkreli, who is currently awaiting trial for securities fraud, said later that “all you people who don't like trump are jealous, stupid and poor! don't make me laugh!” "
I'm sorry...I missed the part where Shkreli is related to a Republican in office or where Shkreli and his company donated large sums of money to Trump's "charity" and lobbied him soon after for favors while he was in a public office.
Keep trying and keep lapping up Clinton like you do...
I thought you guys like the freedom to lobby in our great nation? Are you asking for greater regulation now?
Donating to a private slush fund is not lobbying. There are all sorts of rules and reportings on what political campaigns can do and spend money on, not to mention donations to them are not tax deductible.
Keep slurping up on Hillary...and keep deflecting by saying 'yeah, but...'
Kinda crazy story...no clue how this minor detail isn't being talked about. The CEO of Mylan is Heather Bresch, who happens to be the daughter of WV Democratic Senator Joe Manchin (wonder who helps sponsor some of the govt requirements for the Epipen use...). She also managed to up her own salary something like 900% while cranking up the price.
"Shkreli, who is currently awaiting trial for securities fraud, said later that “all you people who don't like trump are jealous, stupid and poor! don't make me laugh!” "
I'm sorry...I missed the part where Shkreli is related to a Republican in office or where Shkreli and his company donated large sums of money to Trump's "charity" and lobbied him soon after for favors while he was in a public office.
Keep trying and keep lapping up Clinton like you do...
I thought you guys like the freedom to lobby in our great nation? Are you asking for greater regulation now?
So all lobbyist have equal access kinda like all capitalism is the same. Cute hiding behind the regulation/deregulation thing. You'd be scream like a little bitch if the R's were in control. What you have been advocating is cronyism and yeah its wrong when the R's are in power but I guess merit, efficiency, etc are old antiquated ideas too. Whats also funny is you think you are a member of the lefty elite, that 1%. Yet you live on a message board when you are not crashing floatplanes. What happens when you are pink slipped from that DBA job and replaced by a kid from Bangalore for half the wages
The kid from Bangalore has been trying to get a job like mine for the last 15 years. Doesn't matter where the kid is from actually, there is a big difference between writing some SQL and designing a highly optimized system that can handle billions of transactions a day... a kid from anywhere can't do that, and MSFT, Expedia, Amazon, Verizon, Google, Ebay, etc will never trust them with that. But keep living your hate filled fantasy while you are running that MySQL database under your desk....
Comments
http://www.nydailynews.com/news/national/pharma-bro-martin-shkreli-endorses-donald-trump-article-1.2651758
"Shkreli, who is currently awaiting trial for securities fraud, said later that “all you people who don't like trump are jealous, stupid and poor! don't make me laugh!”
"
SELECT *
FROM hot.midgets WHERE height < 49 AND weight > 250
Looks like the SQL derail is alive and well
HTH
#lemming
Keep trying and keep lapping up Clinton like you do...
Keep slurping up on Hillary...and keep deflecting by saying 'yeah, but...'
...and keep supporting that loser Trump.