Error

[smilingjohn]

Hi All

Actaully my script was runing  well unless i added Distinct to it , and now its giving the error .

Can someone tell me where I am wrong ?

ErrorSource: OraOLEDB, ErrorMsg: ORA-01791: not a SELECTed expression

Department:

   SQL

  SELECT 

        Distinct 

        aia.invoice_id,

        AIA.vendor_id "VendorId",

......

and so on

Do i need to mention Distinct before Select or what ?

[tamilarasu · Accepted solution]

Hi,

Try like,

Load distinct *;

SQL

SELECT

        aia.invoice_id,

        AIA.vendor_id "VendorId",

......

[#3]

You can also try Group By instead of Distinct in your script.