Hi,
I use the following query to extract information about a practice in my database. However if the practice system id hasnt been set then the query won't work.
SELECT P.*, S.System_Name FROM Practices P, Systems S WHERE P.Practice_ID = '".$_SESSION['ses_practice_id']."' AND S.System_ID = P.System_ID
Is there a way to allow the query to extract the practuce information even if the system hasnt been set?
Thanks for your help.
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
