it s correct each location have a DB it snot networked I want to re organising this to have one table. In this tables on each location wa have old customers, new customers, and we have customers who go to each location. Wa want to find them for givng a bonus. It s difficult to explain but that s it. for 2 tables it s not too difficult to have results SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.fk_id i take results and begin a new operation with the table 3. After i take results and do new operation with the table 4 and i take results to do innerjoin with the table 5. I m looking for a request to do all of this only with one request. Just because we have any new fidelity card each day and i want to be quick. The 5 tables dont need to be linked, each shop have one on a secure computer not connected on internet. each table is independant. what happens when any client visits multiple locations/stores? we have the id of the card one the DB when the fidelity card is read by a lasercode.