In Boylan, the ledger notes were in the dbo.Note table and could join to a Ledger and Order like so
Code: Select all
select n.*
from Ledger l
inner join Note n on n.NoteCollectionID = l.NoteCollectionID
inner join [Order] o on l.OrderID = o.ID
where o.Number = 'XXXXXXX'