topic-28055

Posts: 434

Joined: Wed Jun 06, 2007 02:58 PM

join two select
Posted: Fri Feb 07, 2014 01:41 PM

Hi,
I have two table in different database (table1 in msacces and table2 in sql server)
I would like to read together.
i.e.
read table1 using odbc connect
read table2 using odbc connect
and then to use the two table by xbrowse.

I do not want to use a dbf file to record table1 and then table2.

any example?

thanks

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)

damianodec

Posts: 434

Joined: Wed Jun 06, 2007 02:58 PM

Re: join two select
Posted: Fri Feb 07, 2014 02:48 PM

Table1 and table2 have the same Field...

Sent from lumia 720 Tapatalk

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)

James Bott

Posts: 4840

Joined: Fri Nov 18, 2005 04:52 PM

Re: join two select
Posted: Sun Feb 23, 2014 03:24 PM

Maybe you could use a temporary array to do a "join" then browse the array.

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10

FiveTech Support Forums

Continue the discussion