SQL Question. Using the script below, 1) display record where "IDT_NUM" is unique (no duplicate). 2) put a pipe (|) deli

[answerhappygod]

SQL Question.
Using the script below, 1) display record where"IDT_NUM" is unique (no duplicate). 2) put a pipe (|)delimeter wrapper around this script so the data come out asshown below.
John | Doe | Good Insurrance LLC | 06-10-2025|...etc
Sasha | Roberst | Best Deal LLC | 05-10-2023|....etc
SELECTTRIM (C.MAIL_ADDR_1) ||', II TRIM (C.MAIL_ADDR_CITY) || , || TRIM(C.MAIL_ADDR_ST) I, II TRIM (C.MAIL_ADDR_ZIP) as "BillingAddress",A.PIGT_NUM as "PIGT Number",INS_CRRY_NAME as "Insurance Carrier Name",INS_EXPIRY DATE as "Insurance Expiration Date",INS_PLCY_NUM as "Insurance Policy Number",B.LANG_CODE as "Languages",LCNS_NUM as "License Number",LCNS_TYPE_CODE as "License Type",VNDR_NAME as "Vendor Name",CNTC_NAME as "Primary Contact",BUSN_PHN_NUM as "Business Phone Number",EMAIL as "Business Email",IDT_NUM as "Identifier Number",
from PGM_INFO_MSTR Ainner join PGM_LOC_LANGS B on A.PIGT_NUM = B.PIGT_NUM;