-
Gandoif989 and srt:
Thanks for the help! I tried to use distinct before the three columns. The query returned 1678 records.
Thanks again!
-
Originally posted by lgaorcl
Do you have any good SQL books to recommend to me?
There are plenty around - but before that (excuse me for being rude) you will have to learn to express yourself simply, logically and precisely. If you can't write down in English (or Icelandic, Swahili, Urdu, Chineese or Malay) what you want, you'll never write SQL.
Do the exercise now - write down on a piece of paper twenty typical rows from that_table, then write down the result you want, then write yourself instructions on how to get there. Then find at least three different ways of misunderstanding the instructions you gave yourself.
If that sounds unkind - remember I'm a lot more forgiving than an SQL interpreter.
-
Originally posted by DaPi
If that sounds unkind - remember I'm a lot more forgiving than an SQL interpreter.
.. and your error messages are more verbose also.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|