subject:"\[sqlite\] filter and sort in CREATE VIEW or CREATE TABLE \?"

Re: [sqlite] filter and sort in CREATE VIEW or CREATE TABLE ?

2006-07-13 Thread Jens Miltner

Am 13.07.2006 um 14:10 schrieb Christian Smith: Inline. ditto Jens Miltner uttered: Hi all, I need to create a temporary table holding ID column values from a number of tables, so that I have a unique way to access the data for display purposes: say I have 2 related tables [snip

Re: [sqlite] filter and sort in CREATE VIEW or CREATE TABLE ?

2006-07-13 Thread Christian Smith

Inline. Jens Miltner uttered: Hi all, I need to create a temporary table holding ID column values from a number of tables, so that I have a unique way to access the data for display purposes: say I have 2 related tables [snip schema] When displaying a filtered subset of the persons with