title: MySQL export specific fields from multiple table into one csv file? CREATE TABLE outputs
body: <p>I need to integrate my e-commerce with the local system.</p>
  
  <p>I need to export specific fields from multiple tables of my database into a csv file.</p>
  
  <p>I need from TABLE jos_virtuemart_products those fields product_sku , product_in_stock , low_stock_notification , product_length , product_width , product_height , product_weight</p>
  
  <p>then</p>
  
  <p>I need from TABLE jos_virtuemart_products_en_gb those fields purodct_name , product_s_desc</p>
  
  <p>then the out put csv file should me imported to another database table that has all those fields from the others 2 table above.</p>
  
  <p>Is it possible to be ran by mysql command in the linux command line? or I will have to figure out other way?</p>
  
  <p>Have some one been in this situation?</p>
  
  <p>Which is the best way to do this itegration?</p>