I am doing i project to combine the production data from different stations,i made some tables in Mysql but when i query the whole production data all the production data are in different talbes can not put them together.i use the Join to put two tables together,this is works,but when to query the whold data sitll where should i select the target table? i do not know how to do this to get the result display after Join these two tables?
Ok,i used the follow code now it works as i thought.
"insert ignore into CCC select DISTINCT st2.`EXT-SN`,st2.`INT-SN`,st2.DATE,st3.DISTANCE,st3.RESULT2 from st2,st3 where st2.`EXT-SN`=st3.`EXT-SN` order by st2.`EXT-SN`;"
