Hi,
I need your advice please. I have a huge paradox database, which consists of many (more than hundred) paradox tables. These tables are located in many different directories. The simplified situation is like I have A, B and a crossref table. The A and the xref tables are in the same directory. The crossref table tells which records from B belongs to a given record in A (and vice-versa) something like master/detail relationship. No problem with the master/detail, but the actual details are in the B table... So what I really would like to do is something like SELECT Btable.*, Xreftable.* FROM Btable, xreftable WHERE Btable.blatt=xref.val using a query. In other words I need a subset of records from table B which belong to a given record in table A. But the tables are in different directories. To stay compatible with the original program I can't modify the structures. Since B contains more blob fields, lookup is not an option. (In addition it's about 40-50 fields in B) Do you have any idea how I could join those tables? Thanks in advance. By(t)e K.L. www.kovacslt.fw.hu mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __________________________________________________ Delphi-Talk mailing list -> Delphi-Talk@elists.org http://www.elists.org/mailman/listinfo/delphi-talk
