//create table
sql="create table em(name int primary key,age int);"\
    "create table idv(id int primary key,name text);"\
    "create table mny(id int primary key,sal int);"\
    "create table lo(name int primary key,addr text);";

//query
sql="select * from lo,em,idv where lo.name=em.name and em.name=idv.name";


//vdbe program

   0 Init             0   38    0               00
   1 OpenRead         2    5    0 2             00
   2 OpenRead         1    2    0 2             00
   3 OpenRead         3    3    0 k(2,nil,nil)  00
   4 OpenRead         0    9    0 2             00
   5 OpenRead         4    4    0 k(2,nil,nil)  00
   6 Rewind           2   32    0               00
   7 Column           2    1    1               00
   8 IsNull           1   31    0               00
   9 Affinity         1    1    0 D             00
  10 SeekGE           3   31    1 1             00
  11 IdxGT            3   31    1 1             00
  12 IdxRowid         3    2    0               00
  13 Seek             1    2    0               00
  14 Column           3    0    3               00
  15 IsNull           3   31    0               00
  16 Affinity         3    1    0 D             00
  17 SeekGE           4   31    3 1             00
  18 IdxGT            4   31    3 1             00
  19 IdxRowid         4    4    0               00
  20 Seek             0    4    0               00
  21 Column           4    0    5               00
  22 Column           3    0    6               00
  23 Ne               6   31    5 (BINARY)      53
  24 Copy             5    7    0               00
  25 Column           0    1    8               00
  26 Copy             6    9    0               00
  27 Column           1    1   10               00
  28 Column           2    0   11               00
  29 Column           2    1   12               00
  30 ResultRow        7    6    0               00
  31 Next             2    7    0               01
  32 Close            2    0    0               00
  33 Close            1    0    0               00
  34 Close            3    0    0               00
  35 Close            0    0    0               00
  36 Close            4    0    0               00
  37 Halt             0    0    0               00
  38 Transaction      0    0 43444 0             01
  39 TableLock        0    5    0 idv           00
  40 TableLock        0    2    0 em            00
  41 TableLock        0    9    0 lo            00
  42 Goto             0    1    0               00