Re: [sqlite] retrieving data from multiple tables

[T&B]

Oops, I meant:

CREATE VIEW MyTables
    AS
          SELECT Field1 AS MyField, otherFields1 FROM MyTable1
       UNION ALL
          SELECT Field2, otherFields2 FROM MyTable2
       UNION ALL
          SELECT Field3, otherFields3 FROM MyTable3
       UNION ALL
          SELECT Field4, otherFields4 FROM MyTable4;

and thereafter simply query it as if it is one big table:

SELECT * FROM MyTables WHERE MyField is desiredValue;

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------