subject:"\[sqlite\] Query Issue"

Re: [sqlite] Query Issue

2007-03-22 Thread Kees Nuyt

Tue, 20 Mar 2007 14:15:52 - Ajay Arora wrote: > [snip] >And it gives me an error saying "e.extract_sequence" does not exist". DROP TABLE IF EXISTS extract_master; CREATE TABLE extract_master ( extract_sequence INTEGER PRIMARY KEY, file_locationTEXT, active

[sqlite] Query Issue

2007-03-20 Thread Arora, Ajay

Hi, I'm trying to run following query in sqllite, select a.extract_sequence,a.file_location,a.active,b.start_date,b.end_date,b.po rtfolio_code,c.status from extract_master a, extract_parameter b, (