Selecting each column (instead of *) and then assigning an alias to designerID from one of the tables (select designerID as GDID......) might work.
Regards, Bhavin. ----- Original Message ----- From: "Wilbert Enserink" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 7:38 AM Subject: temporary table query > hi all > > > > I'm using this query: > > CREATE temporary TABLE temptable SELECT * FROM gallery INNER JOIN designers > ON (designers.designersID=gallery.designersID) WHERE > (LOWER(gallery.omschrijving) LIKE '%$search%' OR LOWER(gallery.productnaam) > LIKE '%$search%' OR LOWER(voornaam) LIKE '%$search%' OR LOWER(achternaam) > LIKE '%$search%') > > now I get the result back: Duplicate column name 'designersID' > DesignersID is a column in table gallery and in table designers-> which > explains my LEFT JOIN. > So I understand that MySQL is trying to build a table with 2 columns with > the same name: designersID... > > anybody knows how to overcome this problem? > > > thx and regards. > > Wilbert > > > ------------------------- > Pas de Deux > Van Mierisstraat 25 > 2526 NM Den Haag > tel 070 4450855 > fax 070 4450852 > http://www.pdd.nl > [EMAIL PROTECTED] > ------------------------- > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
