Anyone know if this type of Query is possible with BAQ?
SELECT X.*
FROM (
SELECT COMPANY, PARTNUM, RESTRICTIONTYPEID
FROM ERP.PARTRESTRICTION
WHERE RESTRICTIONTYPEID <> 'NOREVIEW'
) X
Anyone know if this type of Query is possible with BAQ?
SELECT X.*
FROM (
SELECT COMPANY, PARTNUM, RESTRICTIONTYPEID
FROM ERP.PARTRESTRICTION
WHERE RESTRICTIONTYPEID <> 'NOREVIEW'
) X
Sure thing
There are several threads here on using sub queries to filter an upper level that explain the mechanics.
Thanks. I figured it out as soon as I post this. End up using the InnerSubQuery and got what I need.