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

Stefan Hornburg Racke interchange-users@interchange.redhat.com
Mon Oct 29 12:19:13 2001


Brian Kosick <briank@nacs.net> writes:

> Hello again,
>          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.

$db->query($sql) should grok any valid SELECT statements.

Ciao
        Racke

-- 
Racke happily hacks Interchange and maintains Debian packages like Courier.

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)