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/1170705152268780000'; Though it doesn't look pretty, it returns the right data (my SQL needs a lot of work). Now the thing that I would like to accomplish is to ONLY write the data from the body.body_data table into the outfile. Is that possible? If so, how...? Thanks in advance, RV -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
