Re: [sqlite] Slim down join results (all fields returned)

On 18/04/2009 2:33 PM, flakpit wrote: > If anyone else has a moment and a concrete example instead of sending me > to > tutorials, feel free to step in here. >If you would take a moment to read the fraction of a screen of a >tutorial that I pointed you at (and which contains a concrete

Re: [sqlite] Slim down join results (all fields returned)

> You did. You should still do some SQL tutorials. >In the meantime, I hope the above helps. Adjusted the fieldnames accordingly and your example worked perfectly. Thank you. However, repeating that I should do some SQL tutorials is annoying in extremis. I had been to many SQL tutorials and

Re: [sqlite] Slim down join results (all fields returned)

On 18/04/2009 2:33 PM, flakpit wrote: > If anyone else has a moment and a concrete example instead of sending me to > tutorials, feel free to step in here. If you would take a moment to read the fraction of a screen of a tutorial that I pointed you at (and which contains a concrete example),

Re: [sqlite] Slim down join results (all fields returned)

On Fri, Apr 17, 2009 at 11:33 PM, flakpit wrote: > > If anyone else has a moment and a concrete example instead of sending me to > tutorials, feel free to step in here. > > SELECT * FROM pubs                    ; I want ALL columns from the 'pubs' > table > > WHERE

Re: [sqlite] Slim down join results (all fields returned)

If anyone else has a moment and a concrete example instead of sending me to tutorials, feel free to step in here. SELECT * FROM pubs; I want ALL columns from the 'pubs' table WHERE pub_title LIKE '%salem%' ; Where the title sounds like 'salem' In the pubs table, there is

Re: [sqlite] Slim down join results (all fields returned)

On 18/04/2009 8:24 AM, flakpit wrote: >> SELECT pubs.* from pubs, notes, publishers WHERE ... > > Thanks, but it didn't work the way I expected it to:) > > Now I have my query laid out a lot better and can 'slim' it down from here > > SELECT * FROM pubs > INNER JOIN notes > ON

Re: [sqlite] Slim down join results (all fields returned)

>SELECT pubs.* from pubs, notes, publishers WHERE ... Thanks, but it didn't work the way I expected it to:) Now I have my query laid out a lot better and can 'slim' it down from here SELECT * FROM pubs INNER JOIN notes ON pubs.note_id=notes.note_id ; notes. INNER JOIN publishers ON

Re: [sqlite] Slim down join results (all fields returned)

On Fri, 17 Apr 2009, flakpit wrote: > Currently, I return any needed data like this. > > select * from pubs,notes,publishers where pub_title like '%salem%' > and pubs.note_id=notes.note_id > and pubs.publisher_id=publishers.publisher_id > > And it works except for all fields in the matching

Re: [sqlite] Slim down join results (all fields returned)

> Currently, I return any needed data like this. > > select * from pubs,notes,publishers where pub_title like '%salem%' > and pubs.note_id=notes.note_id > and pubs.publisher_id=publishers.publisher_id > > And it works except for all fields in the matching tables being returned. > > Is