I have a database and under that database I have 2 tables.

Log (which is an event reporting log)

under Log there is field called 'logccsd'

CCSD (which is what identifies our circuits)

under CCSD there is a field called 'CCSD'



When I use my mysql statement I pull all records that match my criteria (In
mysql)

SELECT ccsd.CCSD, ccsd.Description, ccsd.Impact, ccsd.Isolation FROM ccsd,
log WHERE ccsd.CCSD = log.logccsd

It defaults to the last record of CCSD automatically. What I need it to do
is pull from the last record of log where ccsd.CCSD = log.logccsd




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to