MySQL Table Joins

[Anon]

Hi, can someone please tell me how to do a join between 3 tables...

example:
Say I have three tables
customer
orders
sales_person

if i wanted to select all orders, and sales people that entered them that match a customer ID, what is the select statement that I need?

I know this is a MySQL question far more than a PHP but i got nothing back from the MySQL relme and surly some PHP Programmer must have had to do something like this.

Thanks in advance,
Charlie

[Anon]

I may be far of the mark and if so please correct me, but would this work?

FUNCTION Select() {
mysql_query("SELECT c.tid, c.nickname, c.l_name, c.f_name, c.location, c.connection, c.email, c.inc_roster, n.prev_nick, k.prev_clan FROM current as c JOIN prev_nick AS n ON c.tid = n.current_tid AND JOIN prev_clan AS k ON c.tid = k.current_tid WHERE c.tid = $sid", Connect());

As you can see this is going to be a PHP function that may be called several times.

PLEASE HELP!

Regs,
Charlie