Re: update question

David,

> > > > 1) Is there any way you can easily identify the relevant rows in the
> > legacy
> > > > database and export only those?
>
> I guess I'm unclear as to which table you are
> referring to as the LEGACY table.  either way i
> imagine that by looking at a table  or VIEW of the pik
> numbers common to both tables is what i need, so yes I
> can get that. in fact i have now. but how can i use
> that table to update the price fields in inventory

No, I'm talking about the database system that is exporting to text.  Can you
tell it to export only the rows you need?


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco