Re: [sqlite] Views

--- Mario Figueiredo <[EMAIL PROTECTED]> wrote: > On 7/6/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > --- Mike Johnston <[EMAIL PROTECTED]> wrote: > > > I have to join three tables to retrieve bits of data from each. I'm > > > wondering if I use a > view > > > are there any performance issues

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

Re: [sqlite] Views

On 7/6/07, Joe Wilson <[EMAIL PROTECTED]> wrote: --- Mike Johnston <[EMAIL PROTECTED]> wrote: > I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view > are there any performance issues vs. issuing the complete 3 table join query in code. As long as your

[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