Democract Senator's Daughter cranks up price of EpiPen

HoustonHusky said:

OZONE said:

HoustonHusky said:

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.

http://www.cnn.com/2016/08/23/health/epipen-price-mylan-prescription-drugs-increase/index.html
http://www.forbes.com/sites/kellyphillipserb/2016/08/24/that-400-epipen-price-hike-could-hit-your-wallet-even-if-you-dont-need-one/2/#23084cf84176

Small beans compared to the Clinton Foundation, but interesting none-the-less...

Is it as interesting as Martin Shkreli endorsing Trump?

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!”
"

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...

OZONE said:

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.

DeepSeaZ said:

makes sense but I think the data would be more accurate if you used and innerjoin.

OZONE said:

DeepSeaZ said:

SQL porn. Now join PurpleJ and Splooge tables...

OZONE said:

PurpleJ said:

Computer nerd hot talk right here.

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.

ttu_85 said:

OZONE said:

HoustonHusky said:

OZONE said:

HoustonHusky said:

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.

http://www.cnn.com/2016/08/23/health/epipen-price-mylan-prescription-drugs-increase/index.html
http://www.forbes.com/sites/kellyphillipserb/2016/08/24/that-400-epipen-price-hike-could-hit-your-wallet-even-if-you-dont-need-one/2/#23084cf84176

Small beans compared to the Clinton Foundation, but interesting none-the-less...

Is it as interesting as Martin Shkreli endorsing Trump?

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!”
"

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