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)
> 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 alwa
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),
ins
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 pub_title LIKE '%salem%' ; Wher
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 an
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 pubs.note_id=note
>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 pubs.publi
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 tab
> 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 the
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 there any way using
10 matches
Mail list logo