Of course "left join". And "group by" moreover. But how?
For the "group by" i need a sum-like function, which joins the strings.
> >how can i get a recordset constains all records (or records matching a
where
> >exp.) from the Table1 with the c values from the Table2, like this:
> >
> >uid name cs
> >-----------------
> >1 user1 '50 - twenty-three - the reason of life'
> >2 user2 'twenty-three - 303 rulz'
> >3 user3 ''
> >
> >I can make heavy things with mysql, but i'm too small for this :)
>
> Think what you want is "left join". Check your favorite SQL manual for
syntax.
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
