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.
Also, is it quicker to have sqlite do joins on primary keys between tables instead of doing three separate single table queries on the primary key in code? Thanks Mike --------------------------------- Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center.