>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.
Bye,
B.
---------------------------------------------------------------------
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