| Importing DataImport from Database | Parent topic: Import from Database Previous topic: Import from Database Next topic: Convert Table Structure to XML Schema |
Clicking this action opens a dialog box with all the defined database connections:
Figure: Select Database Table Dialog Box
The Import Criteria dialog box opens with a default query string in the SQL Query pane:
Figure: Import from Database Criteria Dialog Box
The dialog box contains the following options:
The SQL Query string is editable. You can specify which fields are considered.
The use of aliases avoids the confusion of two columns being mapped to the same name in the result document of the importing operation.
select s.subcat_id,
s.nr as s_nr,
s.name,
q.q_id,
q.nr as q_nr,
q.q_text
from faq.subcategory s,
faq.question q
where ...