[SOLVED] join table

[rashmi_k28]

Field in ip_details are

name, node, ip

 

 

Fields in name_details are

name, node, used_mem,tot_mem

 

 

How to join two tables and fetch the node,name from name_details and ip from ip_details.

 

 

 

When I use join I get message as ambiguois

 

[teng84]

you should put alias on your fields the error means sql finds two the same field that come form two tables you can paste your script so we can edit your statement

 

 

[zenag]

 

SELECT name_details.name,name_details.node,ip_details.ip FROM name_details leftjoin ip_details on ip_details.name=name_details.name

[zenag]

 

 

left join must have space

SELECT name_details.name,name_details.node,ip_details.ip FROM name_details left join ip_details on ip_details.name=name_details.name

[rashmi_k28]

Thank you so much it worked.