in reply to Re: Question of SQL and an array
in thread Question of SQL and an array

Sorry about that

there are two datafile that has data, the first one is call
PATENTES the datafile looks like this
PAT NAME DATA1 0001 JOE JAVA 12546789 0002 JOHN JRE 12546789 0003 JACK JAVA 12546789
and the other datafile is the one with the general data
the datafile looks like this:

PAT COMPANY PHONE ADDRESS 0001 BEE CO. 8569658965 123 EVERGREEN 0001 AVC CO. 9878528852 321 EVERRED 0001 BEE CO. 8569658965 123 EVERGREEN 0002 TREE CO. 1255648596 696 LOUIS 0002 TEE CO. 4587895254 720 LOUIS 0003 THEE CO. 9568569856 696 LOUIS 0003 TTHE CO. 1985698596 686 MISIS
So basiclly I am looking for a way to get the data out of the CSV using the data in the datafile PATENTES I thought using an array to get the data since PATENTES datafile has no duplicates, I hope this can bring more light to the problem