PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Different data file with different database connection
Different data file with different database connection
Débuté par Paolo Ricciardi, 28 juin 2023 17:13 - 1 réponse
#1
Posté le 28 juin 2023 - 17:13
I have a table with datyabase connection + another table with different database connection, is it possible to make a query?

THK
#2
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 01 juillet 2023 - 18:34
Hi Paolo Ricciardi

It is possible, but you need to provide more info

Do you need to inner join those querys?
What's the purpose for this?

For answer your question yes but I will make an example:

First let name things
TableA have a connection to a DB we will called this DB as DBA
TableB have a connection to DBB

You need to create a query with TableA and it will have a connection to DBA
Then you will create another query called TableB and it will have a connection to DBB

You could execute it and it will work and you will see the data for QueryA and QueryB (A for connection to DBA and B to connection with DBB I mean)

Now I will recall my questions

Do you need to have an inner join with those querys? or are you worry about that you can't have multiple connections with differents data bases and tables?

--
Best Regards
ARV
→ Revenir à WINDEV 2024