in reply to Question of SQL and an array

but did not work is not a good error description. What didn't work, and what did you expect to happen?

Replies are listed 'Best First'.
Re^2: Question of SQL and an array
by ArmandoG (Sexton) on Nov 27, 2007 at 16:40 UTC
    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

    [download]
    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

    [download]
    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
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom