I have an app that I'm building where I'm storing family information in one table, and then the members of a family in another. This just seems to make the most sense. Here's a boiled down version of ...

I'm having a bit of a problem with some SQL. I'm trying to do a match from one table to another. It works perfectly except for the last line. As soon as I add it NOTHING gets updated. I'm using SQL ...

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...