[thelist] SQL: looking for resources, have one question

Chris W. Parker cparker at swatgear.com
Mon Oct 21 13:12:01 CDT 2002


hi.

there are two parts to this post to theList. first part being, frankly
i'm tired of not understanding SQL and i'd like to get some
recommendations for a course of action on how i can better learn to use
it.

1. i have only used Access so far, and so have not played with any other
SQL out there. i'd like to be able to work with SQL Server in the
future. seeing as that i don't have money for that, does MSDE function
the same as SQL Server, minus some performance restrictions? should i
install/configure that so i can learn to use SQL Server syntax?

2. are there any good recommendations for websites and/or books that i
should take a look at that explain in detail (and possibly with pictures
[i'm a visual kind of guy]) what the hell is happening when it comes to
JOINs? (or any other more advanced logic in SQL.)

second part.

i have two tables, like so...

products:
 * ID
 * manufacturerID

manufacturers:
 * ID
 * name

so far i've this SQL statement...

SELECT manufacturerID, ID
  FROM products
    WHERE manufacturerID IN(8,4)
    ORDER BY manufacturerID

what i want to do is NOT pull back the manufacturerID but rather the
Name that corresponds to the manufacturerID. the only way i know HOW to
do this is by using a subSELECT, but i think there is some kind of JOIN
that will do this. i just don't know how and can't find any good
resources, or at least any that i can understand.


thanks for the help.
chris.



More information about the thelist mailing list