u/Inner-Significance41

Hey everyone, I am struggling with learning the self join concept specifically when you are joining the table and it's duplicate on the same column. Why are there duplicate values? What is an example use case for this situation? And lastly regarding the filtering you can do in the WHERE clause, why does it remove the duplicate values? And is that particular filtering logic pretty much the same every time in this situation?

I truly feel like an idiot trying to get my brain to understand this, so please try to explain in the most simplistic way possible.

Thanks!

I've been taking 50mg Vyvanse for over 6 months now with at least 2 IR boosters per day (either Dexedrine or Adderall). I'm finding recently the Vyvanse has not been effective at all at least until I take my first Dexedrine booster. I mean the Vyvanse in general has never lasted long for me, usually 3 hours max.

I've also been on a sort of health journey which started with me cutting out foods and drinks that could work against the stimulants like coffee, and acidic drinks and foods, and it gradually turned into working out 5 times a week and eating clean in general. I've lost 50lbs, stopped having to take my gout and cholesterol meds (under my doc's guidance) and feel so much better in general but the Vyvanse effectiveness has dropped off entirely.

That brings me to my question, has anyone took Vyvanse for a longish time and then switched to Dexedrine Spansules (ER)? I'm considering switching, but wanted to hear some opinions about it.

Thanks!

Anyone have a good experience with this generic manufacturer? I've been taking their generic 50mg for about 2 months, and I already had an issue with longevity (I take 2 pure dextro boosters as well), and the duration/overall effect is just worse.

I'm also wondering if anyone with longevity issues like myself has switched to the brand name Vyvanse and has had significant improvement? Everywhere I look in my research Vyvanse and the generic equivalents are supposed to last for 10-12 hours, I've never had it last half of that.