"Steve Fitzgerald" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I'm trying to create a join statement that pulls out a CompanyName based
> on a given CompanyID that is tied to a specified ContactID.
>
> For example, if ContactID=1 then the corresponding CompanyName might be
> Smith, Inc. depending on what was entered.
SELECT
CompanyName
FROM
Company
INNER JOIN
Contacts
ON
Company.CompanyID = Contacts.CompanyID
WHERE
ContactID=$ContactID
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]