Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

12347 998854 4 12347 998856 8</pre><BR><BR>I need a SQL statement that will use po_ln_no to get the PO number (matches up with po_no in po table) and give the ship_via_cod value from the po table.

Stored procedures that return values must be executed by using the PROC SQL SELECT statement with a CONNECTION TO component. The following example executes the stored procedure read_address, which has ...

Hi I need some help with a select statement in MS SQL. I have a table that need to check if there duplicate items there. The problem is that each items is based off of 4 fields in the table. Here ...

This SELECT statement uses the PROC SQL view SLIB.BADORDR to display joined ORACLE and SAS data in ascending order by the CUSTNUM column and then by the PRODUCT (that is, FIBERNAM) column. The data is ...