JOINing tables is one of the fundamental tasks in SQL, and this article explains three basic syntactical approaches.

Written by Joe Pluta

SQL is the tool of choice for querying relational data, and the whole idea behind relational data is that the tables are related. What this means is that a common field in two tables can be used to tie rows from each table together into a coherent set of data. In SQL, this is performed via the JOIN, which has three distinct syntactical variations. This article will explain the differences, including a recent change that might catch you unaware.

Whether you're a newbie or a seasoned pro, this book has something for you.

Written by Mike Faust

For System i developers, mastering the ability to develop subfile applications is an absolute must! In Subfiles in Free-Format RPG, Kevin Vandever takes the reader through the subfile concept—from start to finish. Unlike other books on the topic, this one specifically focuses on coding subfile applications in free-format RPG and does an excellent job of explaining how to use subfiles in the modern rendition of the RPG language.

Convert old 5250 screens to modern GUI formats in a few easy steps.

Written by Thomas M. Stockwell

Last year, ASNA introduced its ASNA Wings modernization tool, which quickly and efficiently converts the old 5250 green-screen legacy display files into .NET ASPX Web forms. ASNA Wings has been out for a year now, so I made use of an opportunity to take a look at the product under the guidance of Anne Ferguson and Roger Pence. Ferguson is ASNA's co-founder and president, and Pence is ASNA's U.S. customer service and education director.