[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)