Andy's Blog » » 今天写的MySQL查询语句

今天写的MySQL查询语句

备忘一下

SELECT e. * , a. * , i.name, i.add, i.city, i.state, i.code, i.phone
FROM `email` e
LEFT JOIN `account` a ON e.id = a.eid
LEFT JOIN `info` i ON e.infoid = i.id
WHERE e.`id` NOT
IN (

SELECT eid
FROM account
WHERE uid =2
)
LIMIT 0 , 30;

Incoming search terms:

Tags: mysql

本文地址: http://blog.21andy.com/20071120/673.html

1 评论 to “PHP开源CMS之MODx”

  1. wuqiqian 于 2007-11-20 21:26:22 发表:

    我也正在学这个,有空一起交流!