Ryan, I have been to the link below but was under the impression that SQL and SQLite are two different things so I usually just look up SQLite help. I can do simple queries as I did the Kahn Academy training. :-) Most of the queries are straight forward but this one seemed a little tougher. Thanks for understanding and having been where I am now. It make me feel better already. :-) Dave
On 3/7/2015 2:44 PM, R.Smith wrote: > > > On 2015-03-07 10:32 PM, Dave wrote: >> Ryan, >> Thanks for your reply. As I mention in my last post: >> >> I got it sorted out I ended up with this using my SQLite Expert >> Professional (if it matters). > > There are a lot of great tools available for SQLite (possibly moreso > than any other DB system because of the open nature and myriad of ways > it can be used) and SQLitexpert is a favourite of mine too - but the > tool never matters, only the SQL. > >> But I will keep this info for testing to see if it does the same >> thing or can help me in the future. I tried to learn DB with ACCESS >> years ago and never really fully understood it. I would get stuck on >> the relationship part with the keys and the visual flow charts always >> seemed to point from one table to another but the lines pointed to an >> item instead of an ID. Or so it looked like that to me. Never really >> got to use it back then. > > You and us both, you first have to understand relational DB design > before using the arrows and blocks become sensible in any meaningful way. > >> Now I am starting over again with SQLite. And I have made some >> progress, but have a long way to go. Good thing for me is I plan to >> use my database (for now) as basically a "flat file" where my app >> will just use the related data in click events to further process. > > May I suggest checking out http://www.w3schools.com/sql/sql_intro.asp > Other resources are available too, but working through the very simple > lessons and great examples there will switch all the lights on for you > - without a single arrow being drawn. > > Good luck! > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
