201 reputation
38
bio website
location
age
visits member for 3 years, 2 months
seen yesterday

Sep
4
awarded  Notable Question
Jul
7
comment What kind of data type to use for numbering in the Harmonized System?
Any system that requires leading 0s should be taken out behind the barn and shot.
Jan
24
awarded  Popular Question
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