>>If they were prefixed, I'd have to do lots of "Select ... mbr_cust as dzw_cust" or write lengthy Insert ...values ... (mbr_this, mbr_that, ...).
>
>I guess it depends on what kind of SELECTs you most commonly write. In your case, prefixes would slow you down. In my case, using prefixes avoids aliasing in SELECTs.
In this case, the difference is the same :). IMO, SQL fields should be aliased one way or another because there's no sane way to format or tidy them, and this only if it's a join. In a single-table Select, I specifically don't do any aliasing (or use just a one-letter alias) - and you must keep your prefixes.
There are two kinds of lazy programmers...