I am having one heck of a time joining multiple tables and doing Criteria filters within tables I am joining.
This is the query created within BAQ Designer. I want to filter “RevisionNum” but this will not filter anything.
However, if I take the same query and put my filter in my “Where” clause like the following in SQL Server Management, it works fine. How do I get the filter to be within the “Where” clause?
select
[PartRev].[Company] as [PartRev_Company],
[PartRev].[PartNum] as [PartRev_PartNum],
[PartRev].[RevisionNum] as [PartRev_RevisionNum]
from Erp.Part as Part1
inner join Erp.PartRev as PartRev on
Part1.Company = PartRev.Company
And
Part1.PartNum = PartRev.PartNum
where PartRev.RevisionNum like @REv