Newbie HELP. Using SELECT in Query Browser to retrieve records

[Janjs Jangori]

Am new to mysql and have some difficulty in retrieveing data from 3 tables 
using the Query Browser(version 1.0.8).
I have 3 tables (axkde, axuser,axdev). All  3 tables have 
'id','sender','reply'....fields. Id is unique in all 3 tables.
Now I want a query to extract data from the 3 tables. Something like this:

|sender_axkde|f_kde| sender_axuser|f_user| sender_axdev|f_dev|
|...................|........|.....................|........|....................|........|.......
| sowe           |    3  |       sowe       |  16  |    sowe         | 1     
|
|...................|........|.....................|........|....................|........|...........
| joe              | 15   |     joe            |   7   |    joe            | 
52   |

I wrote this sql and had syntax error
SELECE axkde.sender, axuser.sender, axdev.sender
COUNT (axkde.sender, axuser.sender, axdev.sender) AS f_kde,f_use,f_dev
FROM axkde, axuser, axdev
GROUP BY axkde.sender, axuser.sender, axdev.sender;
I read the SQL manual but could not make any improvement on introducing the 
JOIN command in my query.
Assisatnce is highly solicited.
Rehards



I want a select command that can retrieve 'sender' from the 3 tables
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]