I need to be able to do selects on multiple tables, specifying
particular columns in particular tables.
So far, while combing the DBIx examples, I haven't found a way to do
something like the query below. How would I do this?
SELECT quotes.id, quotes.quote, categories.category, users.fname, users.lname
FROM quotes
INNER JOIN categories
ON quotes.category = categories.id
INNER JOIN users
ON quotes.author = users.id;
I'm really trying to wrap my head around the perl data structure way of
representing SQL statements, but the light bulb hasn't switched on yet.
I've been looking for a guiding set of rules as to when to use a hash,
when to use an anonymous array, etc. Is there such?
best,
/dennis
_______________________________________________ List: [email protected] Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
