Re: [PHP] question, about mysql query

LKSunny <[EMAIL PROTECTED]> wrote: > two table, tablea and tableb > tablea > uid, col1, col2, col3 > 1,xx, xx, xx > 2,xx, xx, xx > 3,xx, xx, xx > tableb > id, uid, col1, firstdata > 1, 1, xx, 1 > 2, 2, xx, 0 > 3, 2, xx, 0 > 4, 1, xx, 0 > > i want query tablea, and join tableb, u

Re: [PHP] question, about mysql query

This isn't a PHP question at all. It's a MySQL question. However, answers are below, with forwards to the appropriate lists for archiving purposes. On Mon, Jun 2, 2008 at 9:19 PM, LKSunny <[EMAIL PROTECTED]> wrote: > two table, tablea and tableb > tablea > uid, col1, col2, col3 > 1,xx, xx

RES: [PHP] question, about mysql query

LKSunny [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 2 de junho de 2008 22:20 Para: php-general@lists.php.net Assunto: [PHP] question, about mysql query two table, tablea and tableb tablea uid, col1, col2, col3 1,xx, xx, xx 2,xx, xx, xx 3,xx, xx, xx tableb id, uid, col1, firstdat

[PHP] question, about mysql query

two table, tablea and tableb tablea uid, col1, col2, col3 1,xx, xx, xx 2,xx, xx, xx 3,xx, xx, xx tableb id, uid, col1, firstdata 1, 1, xx, 1 2, 2, xx, 0 3, 2, xx, 0 4, 1, xx, 0 i want query tablea, and join tableb, uid is associate, ok "LEFT JOIN `tableb` b ON a.uid = b.uid", and than