Try this:
SELECT Description, Impact, Isolation FROM ccsd NATURAL JOIN log
or
SELECT Description, Impact, Isolation FROM ccsd LEFT JOIN log USING(logccsd)
Just add on a WHERE conditional to get the required results if necessary.
----- Original Message -----
From: "Ron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 5:32 AM
Subject: [PHP-DB] Relational database
> I am trying to get fields from 2 different tables that have the same field
> name to pull the records from one table
> For example
> mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to
> database");
> @mysql_select_db("$DBName") or die("Unable to select database $DBName");
> $sqlquery1 = mysql_query("SELECT Description, Impact, Isolation" .
> "FROM ccsd, log WHERE ccsd=log.logccsd");
>
> while ($query = mysql_fetch_array($sqlquery1)) {
> $CCSD = $query["CCSD"];
> $Description = $query["Description"];
> $Impact = $query["Impact"];
> $Isolation = $query["Isolation"];
> }
> This code is not working.....help please.........yes I am a newbie!
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
