I am new to this group. I am part of a small website dev shop and we just started using MySQL. I was tasked with the following: Write a perl script(did this part) to open up the MySQL database and create a View (a temp table) from 3 different tables. I thought no problem I know how to do this I do this in Oracle all the time. BEEP! wrong thought. The docs say, no can do especially with TEXT or BLOB datatypes. Does anyone have any ideas on what I can do? The client needs a temp table to be created with data from 3 different tables for info purposes. They just want to do a select on the table to see what they want to see. All help will be welcome. Thank you all in advance....Lupita
__________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php