Gerald Richter schrieb am Fri, 31 Aug 2001 21:03:39 +0200:
>> SELECT ... FROM forumcomment start, forumcomment thread
> What does "forumcomment start" mean. I guess "start" is your table name, but
> what is "forumcomment" ? Sorry, never seen this SQL syntax before.
This is normal SQL. "forummcomment" is the real name of the table. "start"
and "thread" are alias names. I need those because I use the same table
twice since it's self-referencing.
Aliases can also be used in simpler cases if you want to shorten your
SQL:
SELECT * FROM verylongtablename a, anotherlongtablename b
WHERE a.id = b.otherid;
> Yes, DBIx::Recordset splits the !Table parameter between the commas and
> takes every commponent as table name. That has worked quite well so far.
Only until you use alias names for the tables. That's exactly the
source of my problem.
> First of all I have to understand what you like to do...
I hope the smoke is clearing now?
Best regards,
Jochen
--
Jochen Lillich http://geewiz.teamlinux.de
...and that is how we know the Earth to be banana-shaped.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
