link8804 link8805 link8806 link8807 link8808 link8809 link8810 link8811 link8812 link8813 link8814 link8815 link8816 link8817 link8818 link8819 link8820 link8821 link8822 link8823 link8824 link8825 link8826 link8827 link8828 link8829 link8830 link8831 link8832 link8833 link8834 link8835 link8836 link8837 link8838 link8839 link8840 link8841 link8842 link8843 link8844 link8845 link8846 link8847 link8848 link8849 link8850 link8851 link8852 link8853 link8854 link8855 link8856 link8857 link8858 link8859 link8860 link8861 link8862 link8863 link8864 link8865 link8866 link8867 link8868 link8869 link8870 link8871 link8872 link8873 link8874 link8875 link8876 link8877 link8878 link8879 link8880 link8881 link8882 link8883 link8884 link8885 link8886 link8887 link8888 link8889 link8890 link8891 link8892 link8893 link8894 link8895 link8896 link8897 link8898 link8899 link8900 link8901 link8902 link8903 link8904 link8905 link8906 link8907 link8908 link8909 link8910 link8911 link8912 link8913 link8914 link8915 link8916 link8917 link8918 link8919 link8920 link8921 link8922 link8923 link8924 link8925 link8926 link8927 link8928 link8929 link8930 link8931 link8932 link8933 link8934 link8935 link8936 link8937 link8938 link8939 link8940 link8941 link8942 link8943 link8944 link8945

Главная страница | назад

Article #15305: Hetergenious joins

 Question and Answer Database
FAQ305B.txt Hetergenious joins
Category :Database (Miscellaneous)
Platform :All
Product :Applies to all
Hetergenious joins: How do I join files from differing alias
(heterogeneous joins) using a SQL statment?
For each server table, a connection must exist before the
query is executed. A TDatabase can be used to establish the
The SQL statement must use real alias names, as set up in
the BDE configuration utility, not DatabaseName properties
from a TDatabase.
The SQL syntax should be formatted as follows: a double
quote, a colon, a real alias name, a colon, the table name,
and a double quote. See example below.
Leave the DatabaseName property of the TQuery blank, unless
the alias is local. For example, specifying DBDEMOS in the
Query's DatabaseName property will work, but using IBLOCAL
will cause a general SQL error.
7/15/98 3:23:06 PM

Last Modified: 01-SEP-99