Thanks Brian. But another question is, I looked up CREATE TEMPORARY TABLE What I want to know is can I do the following:
create temporary table (select [distinct] jump.name, jump.address, bike.city, bike.state, skate.zipcode, skate.car, skate.name, skate.city from jump, bike inner join skate on jump.name=skate.name where bike.city=skate.city and jump.name=skate.name and (skate.car>0) order by skate.name; ????? This is the type of query that I have to excute to create the temp table. The client wants much info combined into one table. Thanks. If anyone has any other ideas I'm listening!! THANKS for all your help and suggestions. --Lupita "Brian Moon" <[EMAIL PROTECTED]> wrote: >Do you need to create a temp table or a heap table? Temp tables support >those columns fine. Heap tables do not. > >Brian. > >----- Original Message ----- >From: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, August 20, 2002 11:44 AM >Subject: MySQL and creating views...... > > >| 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 >| >| > > __________________________________________________________________ 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
