SELECT INTO VARIOUS TABLES

[MrBaRRon]

Hi everybody,


I have 3 tables which have the same primary key,

I would like to select * (ALL) from these 3 tables in one query where the primary key is the same.

This is my current code into only two tables :


sqlselect_affaires_clients = " SELECT * FROM CHANTIERS JOIN CLIENT_FINAL ON (CHANTIERS.numaffaire_pro = CLIENT_FINAL.numaffaire_pro)"


Set rsselect_affaires_clients = dbconn.Execute(sqlselect_affaires_clients)

Thank U

 

[JohnDTampaBay]

SELECT * FROM CHANTIERS JOIN CLIENT_FINAL ON (CHANTIERS.numaffaire_pro = CLIENT_FINAL.numaffaire_pro) JOIN ThirdTable ON (CHANTIERS.numaffaire_pro = ThirdTable.numaffaire_pro)"

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.