home *** CD-ROM | disk | FTP | other *** search
/ PC World 2001 March / PCWorld_2001-03_cd.bin / Software / Komercni / VAgeJava / images / daxsql1.gif < prev    next >
Graphics Interchange Format  |  2000-08-14  |  69.0 KB  |  790x570  |  8-bit (197 colors)
   ocr: Data Access Builder SmartGuide: Create a schema mapping X Enter the SQL statement for mapping. Select a table to display the column names to help you construct the query. Enter a schema name for dentitication. Type the SQL statement as the query and click the Validate button to verify it. Selected database: TPF a for the SQL query. For Reference : - : - - Enter a name QUERY Tables FT Enter the SQL statement TPF.CUSTDATA (e.g. select * from table1) Columns SELECT T1.CUSNO, T1.FIRSTNAME, T2.SEX, CUSNO T2.BIRTHDATE SEX FROM TPF. CUSTOMER T1, TPF.CUSTDATA - T2 BIRTHDATE WHERE T1.CUSNO == T2.CUSNO ...