Re: [sqlite] DISTINCT and Indexes

Thanks Joe! Just what I was looking for! On 7/7/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > SELECT DISTINCT customers.bill_state as the_result from customers > UNION SELECT DISTINCT invoice_master.bill_state FROM invoice_master > UNION SELECT DISTINCT customers.ship_state from customers UNION

Re: [sqlite] DISTINCT and Indexes

Hey Andrew! Yes, though that's not what I'm trying to accomplish. The software allows entry of *any* text in the field and I want anything previously entered to appear in the lists after that -- that's why all the trouble. Thanks! On 7/8/07, Andrew Finkenstadt <[EMAIL PROTECTED]> wrote: On

Re: [sqlite] DISTINCT and Indexes

On 7/7/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: I have a query to get all states that a user might have entered, it is : SELECT DISTINCT customers.bill_state as the_result from customers UNION SELECT DISTINCT invoice_master.bill_state FROM invoice_master UNION SELECT DISTINCT

[sqlite] Virtual table implementation in Tcl?

Hello, I wonder if there is a function in the Tcl binding which allows to implement virtual tables in pure Tcl. If not, is it planned? Background: I have a database layout with references between a table and certain others which I could not SELECT with a JOIN/UNION view (variable name and