- - * - WhiteUnicorn - * - -




* #WhiteUnicorn/ StartPage/ Documentation/DelphiFAQ >


Frequently Asked Questions

Hetergenious joins

Question:

Hetergenious joins: How do I join files from differing alias (heterogeneous joins) using a SQL statment?

Answer:


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



* #WhiteUnicorn/ StartPage/ Documentation/DelphiFAQ >



- - * - Anastasija aka WhiteUnicorn - * - - LJLiveJournal
PFPhotoFile