Hellion

201 reputation

	201 reputation	bio	website		visits	member for	1 year, 9 months
27 badges		location			seen	21 hours ago

17 Actions

Oct 31	awarded	Yearling
Oct 31	awarded	Scholar
Oct 31	accepted	query to find closest lesser date
Oct 29	awarded	Student
Oct 29	asked	query to find closest lesser date
Jun 8	awarded	Constituent
Jun 8	awarded	Caucus
Jun 8	awarded	Caucus
Apr 18	awarded	Editor
Apr 18	revised	LEFT JOIN conversion to INNER JOIN, can't change FROM clause try a new approach based on better understanding of the problem
Apr 18	comment	LEFT JOIN conversion to INNER JOIN, can't change FROM clause Oh, I see! The problem is not that there are no child rows in the join, but that the joined child record doesn't qualify later on.
Apr 18	answered	LEFT JOIN conversion to INNER JOIN, can't change FROM clause
Mar 20	answered	Why is this Full Outer Join not working?
Nov 1	comment	What are the pros and cons of using my customer codes as a primary key? For the bonus question: technically the ZIP does not necessarily map 1:1 to a city/state; it's a post-office defined boundary, not a politically defined boundary. Realistically, though, I doubt you'd ever get bitten by it. Definitely add city and state as separate fields so you can do things like "list all customers in state ZZ" without having to parse Address3.
Aug 5	awarded	Supporter
Aug 5	awarded	Teacher
Aug 5	answered	when selecting from multiple tables I get a multiplication of the records