Re: Query not returning same results when displaying one column less

I think the outer joins are only on the c1 table, so selecting a.toolid misses the outer join if no c1 values are selected. Either use c1.toolid in the select or outer the a.

And listen to Daniel about patching. Look up "wrong results" in the bugfix docs if you need convincing.

jg

--
@home.com is bogus.
http://news.com.com/U.S.+makes+first+arrest+for+spim/2100-7355_3-5584574.html?tag=nefd.top