[ic] perl sql query more than 1 inner join?
Jon Jensen
interchange-users@interchange.redhat.com
Mon Oct 29 12:21:22 2001
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