« Previous Next »

Thread: Select for two different files to make a relation

Last post 01-26-2007 6:54 AM by LogParser User : Smart. 0 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (1 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 01-26-2007, 6:54 AM

    Select for two different files to make a relation

    Reply Contact

    Hello,

    can anybody give me an answer to this:

    I have two Tab seperated files FILE1.TSV (Field1, Field2, ...) and FILE2.TSV (Field1, Field2). Field1 in File 1 is a Number and

    Related to this number a Text in File 2 should be selected. So I want to relate the two Files in one SELECT Statement like

       SELECT No, Text

       FROM FILE1.TSV,FILE2.TSV

       WHERE FILE1.No = FILE2.No

    Thanks for help!

     
    Tags:
Page 1 of 1 (1 items)
Microsoft Communities