RE: [sqlite] retrieving data from multiple tables

[Kirrthana M]

By getting the search string from previous table im not only retrieving data
from the table4,at each step i have to retrieve data from 3 tables and store
it in the data structure.

-----Original Message-----
From: T&B [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 14, 2007 3:35 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] retrieving data from multiple tables


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]
----------------------------------------------------------------------------
-


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