Posted: Wed Jan 10, 2007 2:34 am
If your data is not huge get the cartesian product that will return you m*n where m is number of rows in file and n is number of rows in other table.
Then you can add filter and put conditions for matching as per your need. So after cartesian product, you will get col1Fromfile, Col1FromTable and so on. Use the condition as follows to send the required rows.
HTH.
Then you can add filter and put conditions for matching as per your need. So after cartesian product, you will get col1Fromfile, Col1FromTable and so on. Use the condition as follows to send the required rows.
Code: Select all
(Col1FromFile='*' Or Col1FromTable=Col1FromFile) And (Col2FromFile='*' Or Col2FromTable=Col2FromFile)...