Mysql Joins

[amkma]

I have created two tables. In one I keep user informations like:
User_id,
User_name,
User_email,
User_IP.

In second table I keep message information like:
email_id
email_text
email_sender_id
email_receiver_id
email_date_id
email_title

I want to join these so that it shows like these result:
email title --- email date --- email from --- email to --- email text

I am a newbie. Please help
thanks

[goreSplatter]

I suppose your aim is to query both of your tables without using mysql_query twice. You'll first have to know which fields connect your two tables. If I'm understanding your problem correctly, these two fields would be user_id and email_receiver_id?

If this is the case, your query should look something like that:

[FONT=Courier New]SELECT * FROM
table_prefixed_with_user
LEFT JOIN (table_prefixed_with_email) ON(user_id = email_receiver_id)
[/FONT]

Additionally, if your goal is to rename the columns' names then replace the * in the query with:

[FONT=Courier New]email_title AS email title[/FONT], etc. (separated by commas)

I'm not sure though, if aliases (the identifiers after AS) are allowed to contain spaces... Also be aware that you'll still have to use the original column names in your WHERE statement otherwise use the HAVING statement for checking values of the aliases...