Attached is some very simple T-SQL code that I cannot correctly construct for whatever reason.
I am simply trying to say "give me SOP30200.SOPNUMBE where this field is in MN010000.NOTETEXT_I (AND ONLY WHERE SOP30200.SOPNUMBE IS IN MN010000.NOTETEXT_I FOR GOODNESS SAKE!!!!)
I mean, that's very straightforward. But, that is not the result that SQL is giving me. For whatever reason it is givng me the results seen in the attached file.
Evidently, I can't do basic T-SQL scripting. But, I don't get why T-SQL is defying all sense of logic. Makes no sense to me. whatinthefreakinworld.rpt
select 'Approved' as [Status], SOP30200.SOPNUMBE as [Quote No.], MN010000.NOTETEXT_I
INNER JOIN MN010000 on convert(char(1),SOP30200.SOPNUMBE) = convert(char(1),MN010000.NOTETEXT_I)
where SOP30200.SOPTYPE = '1' and (convert(char(1),SOP30200.SOPNUMBE)) in (convert(char(1),MN010000.NOTETEXT_I))