Hi Rob,
That is just what I need. I can't use 'join' very well yet.
Thank you very much.
--
King Kwok
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2008/2/18 King C. Kwok <[EMAIL PROTECTED]>:
> table users
>
> iduser_iduser_name
> 1 M11 Shirley
> 2 M12 Bruce
> 3 M13 Fred
> 4 M14 Albert
> 5 M15 Elizabeth
> 6 T11 Helen
> 7 T12 Tracy
> 8 T13
table users
iduser_iduser_name
1 M11 Shirley
2 M12 Bruce
3 M13 Fred
4 M14 Albert
5 M15 Elizabeth
6 T11 Helen
7 T12 Tracy
8 T13 Charles
9 T14 Jack
10 T15 Ann
table jo