Hola queria ver si alguien me podria ayudar... tengo 3 tablas con varios campos, el unico campo repetido es el nombre del cliente... pero como se repite muchas veces no puedo relacionar las tablas... ...mi pregunta es...... se puede hacer una consulta para extraer todos los datos de un cliente que esta en todas las tablas?
query multiple unrelated tables
- Thread starter dami
- Start date
- Local time
- Today, 01:28
- Joined
- Jan 23, 2006
- Messages
- 15,456
Translated message:
Hello, I wanted to see if someone could help me... I have 3 tables with several fields, the only repeated field is the name of the client... but since it is repeated many times I cannot relate the tables... ...my question is ...... Can a query be made to extract all the data of a client that is in all the tables?
@dami,
Please post in English. You can use Google translate to translate from your mother tongue to English. Post in both languages if you think it's necessary. But many will not look at your post if it isn't translated.
As for your specific question:
I suggest you post a copy of your database (zip format) so that readers see the issue in context. Once readers see the data, I'm sure you'll get more focused responses.
Good luck.
Hello, I wanted to see if someone could help me... I have 3 tables with several fields, the only repeated field is the name of the client... but since it is repeated many times I cannot relate the tables... ...my question is ...... Can a query be made to extract all the data of a client that is in all the tables?
@dami,
Please post in English. You can use Google translate to translate from your mother tongue to English. Post in both languages if you think it's necessary. But many will not look at your post if it isn't translated.
As for your specific question:
I suggest you post a copy of your database (zip format) so that readers see the issue in context. Once readers see the data, I'm sure you'll get more focused responses.
Good luck.
GPGeorge
George Hepworth
- Local time
- Yesterday, 22:28
- Joined
- Nov 25, 2004
- Messages
- 2,469
Aparece que su base de datos no es "normalizado". Cada tabla debe tener un campo con valores únicos. Este campo sera "Primary Key". Si sus tablas no tienen esta característica, hay que ponerles en forma normalizadas. Por lo tanto, favor sube su base de datos. Alguien le pueda ayudar con eso.
"It appears that your database is not "normalized". Each table must have a field with unique values. This field will be "Primary Key". If your tables do not have this feature, you have to put them in normalized form. So, please upload your database. Someone can help you with that."
GPGeorge
George Hepworth
- Local time
- Yesterday, 22:28
- Joined
- Nov 25, 2004
- Messages
- 2,469
¿Que grande es?
SHANEMAC51
Active member
- Local time
- Today, 09:28
- Joined
- Jan 28, 2022
- Messages
- 310
21mb is not much, the archive will probably be less than 7 MB, it seems to be allowed by the forum
