Subqueries

[Johnny Burfelt]

Hi!

I have a problem that I could use some help with. Here it is:

I get datafiles(*.csv) sent to me from varios suppliers. I wish to import these into my business-system. However all files are different depending on with supplies that sent then. That really is´nt a problem as long as I could change the data in one of the columns. So I figured that if I make one table that contains the definition then I could use this to replace the data in the column to the correct values. The datafiles I get contains 5000 to 70000 lines, separated by ;

Basicly this is what I want to do:

Read the value from the first table.
Use this value to search for the right replacement in the second table.
Update the first table with the replacement.
Repeat theese steps to the end of first table.

I have tried to use subqueries but cant figure it out. Do I need to store the value from the first and second tables temporary? Any help at this time would be great =)

// Johnny



Edited 2 time(s). Last edit at 04/07/2008 03:59AM by Johnny Burfelt.