On Sat, 15 Nov 2003 16:23:16 +0100, Steen Brølling wrote:
> Det har jeg forsøgt - kan du gi' et tip om hvilke funktioner jeg skal
> lede efter!??
Du skal ikke benytte særlige funktioner. Det er et spørgsmål om at
specificere kolonnenavnene lidt mere indgående:
You can refer to a table as tbl_name (within the current database), or
as dbname.tbl_name to explicitly specify a database. You can refer to
a column as col_name, tbl_name.col_name, or db_name.tbl_name.col_name.
You need not specify a tbl_name or db_name.tbl_name prefix for a column
reference in a SELECT statement unless the reference would be ambiguous.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1461
--
Greetings from Troels Arvin, Copenhagen, Denmark