Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 Hetergenious joins


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 connection. 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.

    Example:
      SELECT ITEMNO, B.VENDORNO
        FROM ":DBDEMOS:ITEMS" A, ":IBLOCAL:VENDORS" B
        WHERE A.VENDORNO = B.VENDORNO
    

     



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use