Re: [Squirrel-sql-users] feed a CSV file into a IN statement

[John H. <jh...@im...>]

On Sat, 25 Feb 2017, John Hardin wrote:

> (2) write some SQL to create a work table (e.g. t_pasta) with one column of 
>
> SELECT pasta FROM menu WHERE pasta IN (SELECT pasta FROM t_pasta_file);

Oop - apologies for the editing error there, it should of course be:

   SELECT pasta FROM menu WHERE pasta IN (SELECT pasta FROM t_pasta);


-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Insofar as the police deter by their presence, they are very, very
   good. Criminals take great pains not to commit a crime in front of
   them.                                             -- Jeffrey Snyder
-----------------------------------------------------------------------
  432 days since the first successful real return to launch site (SpaceX)