Hi,

I a list of test results in one table, and another table which stores
attachments in blob fields.
so, in a join, each test result may show up one or more times, depending on
the number of attachments it has. I would like to do something like

select * from test_results
left join first 1 skip 0 attachments
where ...

But it does not seem to work.
How can I accomplish that? Am I borking the syntax, or first/skip is really
only valid on the main SELECT statement?