Trying to join 2 tables in mysql-Help!

[canadian_angel]

I am trying to join two tables and havent been very successful, can anyone please help!

The two tables are joke and author; I need to get the authors name and email address in the joke table! The database is ijdb;

 

 

mysql> USE ijdb;

Database changed

mysql> SELECT LEFT(joketext, 20), authorid FROM joke;

+----------------------+----------+

| LEFT(joketext, 20)  | authorid |

+----------------------+----------+

| Why did the chicken  |    0    |

| What is a cows favor |    0    |

+----------------------+----------+

2 rows in set (0.02 sec)

 

mysql> SELECT * FROM author;

+----+-----------------+-------------------+

| id | name            | email            |

+----+-----------------+-------------------+

|  1 | fredl          | fredl@home.ca    |

|  2 | john adams      | johna@hotmail.com |

|  3 | tim horton      | timmy@home.ca    |

|  4 | colonel sanders | colonels@home.ca  |

+----+-----------------+-------------------+

4 rows in set (0.00 sec)

 

mysql> SELECT LEFT(joketext, 20), name, email

    -> FROM joke, author WHERE authorid = author.id;

Empty set (0.00 sec)

[bh]

Hi,

 

ids in joke table: 0, 0

ids in author table : 1, 2, 3, 4

 

theres no matches.