Re: SQL exception join: Left side now needs data combined from two tables

[rob@xxxxxxxxx]

As a general rule, avoid SELECT *.  Select just the fields you need 
instead.  For example if you do a SELECT ICLAS, COUNT(*) AS NbrIclas FROM 
IIM GROUP BY ICLAS and you have an index on iclas then the SQL optimizer 
only has to read the index and never process the table.  I know, I know, 
the data is not in an index - it's in the table.  Maybe I am saying it 
wrong, but it just makes more sense in iNav's Visual Explain.  Go listen 
to Tom McKinley from IBM sometime and get the details.  (John Sears for 
the next generation.)
Joe, I am sure that you just said that because that wasn't the meat of 
your explanation and you didn't want to get sidetracked.  Maybe replace 
the asterisk by an ellipses?

Rob Berendt