On 7/7/06, Roger <[EMAIL PROTECTED]> wrote:
I have the following query
CREATE VIEW MyStuff AS
SELECT Com . CompanyID CompID , PublicationID PubID ,
Your SQL looks very confused.
Are there really spaces around the period here or is that just in
this message? Spaces are important for the engine to parse
what you mean.
Do you intend by writing two names for each
column to create an alias for the columns?
As in " PublicationID PubID "
Which is the real column name from the source table
and which is your alias? From this query:
Select *
>From MyStuff
Where CompID = 3562;
It looks like CompId is the column name but you
place it second in your other query. The second name
in most SQL syntax is the alias, not the real column name.
--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite
Cthulhu Bucks!
http://www.cthulhubucks.com
