[sqlite] CTE for a noob

2016-03-09 Thread R Smith
On 2016/03/09 10:01 PM, David Raymond wrote: > For my own clarification, the statements quoted way down below aren't exactly > equivalent, correct? > > "For each pair of columns identified by a USING clause, the column from the > right-hand dataset is omitted from the joined dataset. This is th

[sqlite] CTE for a noob

2016-03-09 Thread David Raymond
-Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Tuesday, March 08, 2016 12:11 PM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] CTE for a noob On 2016/03/08 5:02

[sqlite] CTE for a noob

2016-03-08 Thread R Smith
On 2016/03/08 5:02 AM, Stephen Chrzanowski wrote: > Now I'll have to use USING a bit more often to get the drift and get out of > this multi-call thing. I sort of see what is going on here, but practice > is whats needed. "USING" has three uses in SQLite, first to enlist a virtual table, secon

[sqlite] CTE for a noob

2016-03-08 Thread Drago, William @ CSG - NARDA-MITEQ
sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski > Sent: Monday, March 07, 2016 9:47 PM > To: General Discussion of SQLite Database > Subject: [sqlite] CTE for a noob > > I'd like to lea

[sqlite] CTE for a noob

2016-03-07 Thread Stephen Chrzanowski
Awesome... And no CTE. General over complications and over thinking and tunnel-visioned on my part. I just had to tag on whatever sort order I want, and voila. Appreciated. Now I'll have to use USING a bit more often to get the drift and get out of this multi-call thing. I sort of see what is

[sqlite] CTE for a noob

2016-03-07 Thread Igor Tandetnik
On 3/7/2016 9:47 PM, Stephen Chrzanowski wrote: > Currently my application makes two queries to the database. One to get the > list of projects via [ select ProjectID,Description from Projects order by > Description ] > > It then goes through each record retrieved and then gets another query via >

[sqlite] CTE for a noob

2016-03-07 Thread Stephen Chrzanowski
I'd like to learn how to use CTEs by example when working on my own project, by mutating it from individual calls into one clean call. I looked at the page (As I said in my previous email/note/post(?)) and just thought I'd put this question out there. Given I have the schema posted here: http://p