Re: SELECT data FROM two tables into outfile

From: "List User" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Monday, February 5, 2007 4:19:08 PM (GMT-0500) US/Eastern Subject: SELECT data FROM two tables into outfile Hello list: Need some help with the following query: mysql> SELECT header.date_in,header.pid,he

SELECT data FROM two tables into outfile

Hello list: Need some help with the following query: mysql> SELECT header.date_in,header.pid,header.status,body.body_data from header,body where header.date_in='1170705152' and body.date_in=header.date_in and header.pid='26878' and body.pid=header.pid into outfile '/tmp/mysql/117070515226878'