using alias and wildcards in SELECT
Posted on 2009-04-21
i'm moving from using access as a backend for my websites to using mySQL... generally the SQL (so far) has been behaving itself, but i've come across a problem...
in access SQL you could use the following :
SELECT related_items.show_ AS RShow, products.show_ AS PShow, * FROM related_items, products WHERE product_id = "& varID &" AND products.id = related_id AND products.show_ = true
this will return me all fields of both tables and gives an alias to the "show_" field because both tables have a field named like this...
this doesn't work in mySQL... i have to name all the fields in the SELECT....
does anyone know if there is a way to get this to work in mySQL, or should i just name all the SELECT fields?