On Wed, Aug 24, 2005 at 23:12:17 -0700,
Bill Moseley <moseley@xxxxxxxx> wrote:
> I need a little SQL help:
>
> I'm trying to get a subselect working inside a view.
Unfortunately you didn't show us what you tried. My guess would be that
you didn't enclose the subselect in parenthesis.
The distinct on solution that was suggested is probably a better way to
go anyway.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
