[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] perl sql query more than 1 inner join?
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
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users