Re: adding join conditions with DB_DataObject
| From: | Ian P. Christian | Date: | Fri, 04 Feb 2005 15:46:40 +0000 |
| Subject: | Re: adding join conditions with DB_DataObject | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-17386@lists.php.net to get a copy of this message | ||
On Friday 04 February 2005 15:36, bertrand Gugger wrote:
> Are the " extra ? Do you like to link on a constant ?
> Excuse me if it's a bloody question.
Yes, I intend to join on a condition where Attribute.Attribute is equal to a
string "Framed-IP-Address".
This is what i'm trying to achive:
SELECT
raduser.* , radreply.Value as ip
FROM raduser
LEFT JOIN radreply AS radreply
ON radreply.UserName=raduser.username
AND Attribute = "Framed-IP-Address"
WHERE raduser.customerId LIKE "%MAS02%";
Kind Regards,
--
Ian P. Christian
http://pookey.co.uk
Attachment: [application/pgp-signature]
Attachment: [application/pgp-signature]