Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- "PUBLIC"."CUSTOMERS"."CUSTOMERNUMBER",
- "PUBLIC"."CUSTOMERS"."CUSTOMERNAME",
- "PUBLIC"."CUSTOMERS"."CONTACTLASTNAME",
- "PUBLIC"."CUSTOMERS"."CONTACTFIRSTNAME",
- "PUBLIC"."CUSTOMERS"."PHONE",
- "PUBLIC"."CUSTOMERS"."ADDRESSLINE1",
- "PUBLIC"."CUSTOMERS"."ADDRESSLINE2",
- "PUBLIC"."CUSTOMERS"."CITY",
- "PUBLIC"."CUSTOMERS"."STATE",
- "PUBLIC"."CUSTOMERS"."POSTALCODE",
- "PUBLIC"."CUSTOMERS"."COUNTRY",
- "PUBLIC"."CUSTOMERS"."SALESREPEMPLOYEENUMBER",
- "PUBLIC"."CUSTOMERS"."CREDITLIMIT"
- FROM
- "PUBLIC"."CUSTOMERS"
- WHERE
- "PUBLIC"."CUSTOMERS"."COUNTRY" = 'USA'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement