amead <[EMAIL PROTECTED]> writes: > Brass Tilde wrote: > >>>>>select ID, >>>>>(select SERVER_ID from A where A.ID=B.GROUP_ID) as GROUP_ID
> Hmm.. thanks but I'm still confused... isn't the above an example of a > non-static query that used variables from the main query? If it uses variables from the main query, then by SQLite's definition, it's not a static query. Another way to put it, is that subqueries in SQLite may not use variables from the main query. Derrell