Each order in my table has more than one note.
I need to select only orders that don't have a note that starts with 'Billing: '
Select order from OrderNotes where text.....
attached is a sample of what the select would look like.
attached highlighted orders should not be included. (Because they have a note that starts with 'Billing: '
The not highlighted is what I need. (I only need the order) --- Example Column 'k'
Your help is appreciated.