Hi there. I've been outsourced and the data over here is not in that great a shape. I've found that things that should have a one to many relationship, some of the many's are there, but the one is gone (i.e., inventory entries that have no corresponding items table entry). It's really fun :).

Anyway, to play it safe I've decided that I need to use a left outer join and a bit more logic for everything I create, just to cover my butt. I was going to write a routine to do that (since archaic 2.6 doesn't have it to the best of my knowledge :) ) but I thought I'd ask if anyone out here has done something like that already.

Thanks!