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

Re: [sqlite] DISTINCT and Indexes

> 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 SELECT > DISTINCT invoice_master.ship_state from invoice_master; > > Can anyone help speed

[sqlite] DISTINCT and Indexes

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 customers.ship_state from customers UNION SELECT DISTINCT