Re: [sqlite] How do I do this join on multiple columns?

2009-03-02 Thread Greg Palmer
yaconsult wrote: > SQL newbie here. I have data in a couple of tables that I need to relate. > But I don't know how to relate on more than one column. I'll not go into > detail about why the data is formed the way it is - it comes from other > programs. > > For example, let's say there are a cou

Re: [sqlite] How do I do this join on multiple columns?

2009-03-02 Thread Greg Palmer
Rich Shepard wrote: > On Mon, 2 Mar 2009, yaconsult wrote: > > >> SQL newbie here. >> >If you'll be doing a lot of coding in SQL, take a look at Joe Celko's > other books. He's been writing on database issues for more than a quarter > century, and I remember reading his columns in DBMS

Re: [sqlite] How do I do this join on multiple columns?

2009-03-02 Thread BareFeet
Hi ya (well that's the only name you give ;-) ) > SQL newbie here. I have data in a couple of tables that I need to > relate. > But I don't know how to relate on more than one column. > For example, let's say there are a couple of tables: > > server login name last_login email ... > > and we h

Re: [sqlite] How do I do this join on multiple columns?

2009-03-02 Thread Rich Shepard
On Mon, 2 Mar 2009, Rich Shepard wrote: > Two books you should seriously consider purchasing are Rick van der Laan's Correction: his name is Rick van der Lans. Rich -- Richard B. Shepard, Ph.D. | IntegrityCredibility Applied Ecosystem Services, Inc.|

Re: [sqlite] How do I do this join on multiple columns?

2009-03-02 Thread John Machin
On 3/03/2009 12:48 PM, yaconsult wrote: > SQL newbie here. I have data in a couple of tables that I need to relate. > But I don't know how to relate on more than one column. I'll not go into > detail about why the data is formed the way it is - it comes from other > programs. > > For example, l

Re: [sqlite] How do I do this join on multiple columns?

2009-03-02 Thread Rich Shepard
On Mon, 2 Mar 2009, yaconsult wrote: > SQL newbie here. Allow me to offer a recommendation rather than a solution to your problem. (I'd want more information on the attributes in each table before suggesting a SELECT statement.) Two books you should seriously consider purchasing are Rick v

[sqlite] How do I do this join on multiple columns?

2009-03-02 Thread yaconsult
SQL newbie here. I have data in a couple of tables that I need to relate. But I don't know how to relate on more than one column. I'll not go into detail about why the data is formed the way it is - it comes from other programs. For example, let's say there are a couple of tables: server logi