Re: Change field contents on select

[Peter Brawley]

The usual way to do that is with a keyed lookup table, eg in your case parts(partno, name, manufacturer, ... ) so you can write something like ...

select ..., parts.name, ...
from orders
join parts using(partno)
...