How can I Make 1 table out of 3

[elentz]

I have 3 tables that I want to take information from each and make a 4th table. Each record in the individual tables has a id number that links the information For example:

table A:

id
Name
phone
Fax Email

Table B:
id
address
city
state
zip

table C:
id
salesman
other phone

Can someone give me a clue how I can accomplish this? I know enough that I will need to use a join of some sort. I will need to do this many times, at least every time I need to use the end table. I am using MySql 5.0

Thanks for any help

 

[johnwm]

You can do it 'on the fly' rather than creating a new table each time you want to do a query

Have a look here:

http://dev.mysql.com/doc/refman/5.0/en/select.html

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[elentz]

Thanks john for the reply. What I am trying to do is get a table setup so I can use it to get the information into my palmpilot. This table will be used by a PHP script that will change into a palm DB that I can then get into the palm device. I assume I will need to join the tables and then insert the data into the table.

 

[johnwm]

I suspect that php can use a query just as easily as it can use a table!

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints