[ic] perl sql query more than 1 inner join?

[Jon Jensen]

On Mon, 29 Oct 2001, Brian Kosick wrote:

>          I realize that sql lookups through the [query] tag is limited to 1
> join.  My question is if you drop to a [perl] tag, and use the
> $db->query($sql) syntax can you use more than one join?  I have a simple
> query that I'm working on that I can't seem to get to work in IC but works
> from the psql prompt.

Off the top of my head, you should be able to put however complex SQL you
want in [query sql="..."]. In any case, you definitely can in [perl] with
$db->query("...").

Jon