Subject Re: [ib-support] join-sort question
Author Svein Erling Tysvær
>I think i should have used a guid as a hidden unique-id.
Yep, in general it is better to have one unique identifier with no meaning,
rather than requiring a "double link".

>i did try the 'order by' (and and both situations
>report no column of this name, so no fix yet!
Well, you can always try ordering by its ordinal position, e.g.

select p.unique_id,, s.additional_info,
from patients p
left outer join patientstatus s on (p.unique_id=s.unique_id)
order by 2

This should work,