Re: [sqlite] inner joins on prepared statements

2009-07-28 Thread Igor Tandetnik
Shaun Seckman (Firaxis) wrote: >Say I have the following prepared statement "select > B.foo from A inner join B on A.bar = B.bar where A.foo = ?" used to > populate values from a reference table. If I intend on executing this > statement several times with different bound values,

[sqlite] inner joins on prepared statements

2009-07-28 Thread Shaun Seckman (Firaxis)
Hello All, Say I have the following prepared statement "select B.foo from A inner join B on A.bar = B.bar where A.foo = ?" used to populate values from a reference table. If I intend on executing this statement several times with different bound values, is it better for me to gen