* Wilbert Enserink
> 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)
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
