Re: Relational database

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" <allenr@fwd.areur.army.mil> To: <php-db@lists.php.net> 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 > >