Hi Kirrthana,
I have created a database with four tables,i have to search and
retrieve data from all the four tables based on the entry i get
from the previous table and display all the entries,could anybody
tell how to do it.
I'm not sure what you mean. If you mean you have four tables w
lite-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 Fi
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, otherFields
I have four tables like Mytable1,Mytable2,Mytable3,Mytable4
Mytable1 and Mytable2 have one similar field rest al different,
Mytable2 and Mytable3 have one similar field rest al different,
Mytable3 and Mytable4 have one similar field rest al different,
i have to select from four tables by matching
with all these field.
-Original Message-
From: T&B [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 14, 2007 12:44 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] retrieving data from multiple tables
Hi Kirrthana,
> I have created a database with four tables,i have to
Hi Kirrthana,
I have created a database with four tables,i have to search and
retrieve
data from all the four tables based on the entry i get from the
previous
table and display all the entries,could anybody tell how to do it.
I'm not sure what you mean. If you mean you have four table
Richard Stern wrote:
Hi all.
I'm using sqlite in VC++ 2005.
When I started this I knew nothing about sqlite or indeed SQL at all so its
been tough going trying to work out how this all works.
So far I have created a database and a table and added columns and rows
filled with data. But I'm havin
Hi Richard
>> You don't need a Callback-Function in any case. Try it
>> without
> I'm confused.
> How does the SELECT command return any data? In what
> form would it give you this data back? There doesn't seem to
> be a pointer to pass by reference and no out variables.
The Prepare-Command
> > I tried:
> > sqlite3_exec(AccDataBase,"SELECT Name,Address FROM Accounts WHERE
> MemberNo =
> > 2;",Callback(cError,10,&result,&Names),test,&cDatabaseError);
>
> You don't need a Callback-Function in any case. Try it
> without
I'm confused.
How does the SELECT command return any data? I
Am 14.09.2006 um 02:11 Uhr haben Sie geschrieben:
> I'm using sqlite in VC++ 2005.
> When I started this I knew nothing about sqlite or indeed SQL at all
so its
> been tough going trying to work out how this all works.
I started so too ;-)
> I tried:
> sqlite3_exec(AccDataBase,"SELECT Name,A
10 matches
Mail list logo
