I am trying use an SQL statement within VB 6.0 to query against two different tables that have the same field names. Here is what I have tried that does not work:
SELECT DISTINCT [Trustee Num], [Trustee Num] FROM [BkrpRcon], [BkrpList] ORDER BY [Trustee Num]
I'm no SQL expert so I have no idea what else to try. Thanks in advance for any advice.