Tired of writing one-time RPG or Cobol programs to do special or unique things with your tables and data? In many cases you can use SQL instead. In this session you will learn valuable and time saving techniques with SQL that let you avoid writing code. You will learn how to use SQL Subquery or Subselect in an SQL SELECT, INSERT, UPDATE, and DELETE statement to reference mutiple tables without having to do a join of the tables involved. You will learn how to summarize data, identify potential duplicate rows in a table, and more. This session is based on the SQL function available in V5R1 of OS/ 400, assumes you have a basic understanding of relational database concepts and SQL, and assumes you are familiar with using the SELECT, INSERT, UPDATE, and DELETE statements.