in reply to Re: dbi question
in thread dbi question

Actually, and I'm no DBA, the OP looks more to me like a situation to use a JOIN of some sort. Your example may be a bit more simple than the general case, though. 

  SELECT ri.name FROM reportindex AS ri, favorite_reports AS fr WHERE 
+ri.report_id = fr.reportindex_id

[download]
Or something like that.

Replies are listed 'Best First'.
Re^3: dbi question
by FitTrend (Pilgrim) on Mar 04, 2005 at 21:40 UTC

    This is true. I was being general. But you do bring up a good point that you should use SQL statements when possible to reduce the amount of perl code to manage.

    /- M a r c -/

[reply]

In Section Seekers of Perl Wisdom