Andy

Broward County, FL

Age: 25

Literature -> Computer Science -> Chemistry -> Linguistics student. Don't ask.
Currently a research analyst in compliance for a large corporation.

I am a big fan of chocolate milk.

1d
comment Complex joins with counts not dependent on all tables
@jbarker2160 I tried using INNER JOINs instead of left joins, and the first two columns returned the same result which should not happen.
1d
comment Complex joins with counts not dependent on all tables
However, don't INNER JOINs pare down the result set, making order important? For instance, if record 2 appears in table 2 and 3, but record 3 appears in table 3 but not 2, INNER JOINing Tables 1 and 2, followed by 1 and 3 would be missing record 3 because it was not present in 2. Or, is my understanding flawed?
1d
asked Complex joins with counts not dependent on all tables
Sep
30
awarded Explainer
Sep
30
awarded Popular Question
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
1 2 3 4 5