Question3Replies221Views DyanG412 Member since 2013 212 posts Hawaii Medical Service Association Posted: 3 years agoLast activity: 3 years 8 months ago Closed Solved "PCO" in SQL statementPRPC uses "PCO"."ColumName" as "Property Name" syntax in the sql statement. What is the keyword "PCO" and what PRPC requires it for?×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoUpdated: 3 years agoMarc Alderman PEGA replied to DyanG412PCO is just an alias in the query for whichever table is being selected from. See some examples here. https://www.w3schools.com/sql/sql_alias.asp Accepted Solution Posted: 3 years agoHaritha12 PEGA replied to DyanG412Hi, I believe it is just an alias to the table name, created by prpc internally , to look the query more readable as SELECT "PC0".PropA AS "PropA" , "PC0".pzInsKey AS "pzInsKey" FROM dbo.pc_Sae_HRServices_Work "PC0" WHERE "PC0".pxObjClass = 'Sae-HRServices-Work-ABC' When we execute a report, to a main table, the alias will be maintained as PCO. If we use joins, join prefix will be used as an alias name. Posted: 3 years agoSandeep46 OCBC Bank replied to DyanG412Hi, PC0 is just an Alias for table name. For many Databases, Tables might needs to be called/identified using Schema name(Schema_NAME.TableName). As per my understanding, For using column names, it is easier to use "PC0".ColumName(Alias for table) rather than calling Schemaname.TableName.cloumn name(Schema name wont be same for all customers).