|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 patients.name' (and p.name) and both situationsWell, you can always try ordering by its ordinal position, e.g.
>report no column of this name, so no fix yet!
select p.unique_id, p.name, s.additional_info, s.name
from patients p
left outer join patientstatus s on (p.unique_id=s.unique_id)
order by 2
This should work,