Re: put text list into table form

On 1/25/06 9:23 PM, "Web2cad" <alex(at)web2cad(dot)co(dot)jp> wrote:

> Hi
> I have a list of cities stored in flat file that I would like to left join
> with another table.

Why not just do:

Select * from table2 where table2.city in ('city1','city2','city3');

Is that what you ultimately want to do?

> The file looks like this:
> city1,city2,city3

Sean