¿Cómo combinar múltiples consultas SQL en una sola? [cerrado
Tengo estas múltiples consultas sql que quiero agrupar en una sola consulta, para evitar enviar múltiples solicitudes a la base de datos desde mi aplicación (quiero recibir todos estos datos de una sola vez):
1) select pin, officeNum, isVeteran from table18 where pin = 123;
2) select streetAddress, apartmentAddress, cityAddress, stateAddress from table1 where case = (select case from table18 where pin = 123);
3) select unitAddress, cityAddress, streetAddress, apartmentAddress from table5 where pin = 123;
4) select unitAddress, cityAddress, streetAddress, apartmentAddress from table55 where seqNum = 0 and rfa = (select rfa from table18 where pin = 123);
5) select unitAddress, cityAddress, streetAddress, apartmentAddress from table103 where histCode = 0 and case = (select case from table18 where pin = 123);
6) select phone, email from table715 where histSeqNum in (select max(histSeqNum from table715))
and histCode in (select max(histCode) from table715)
and case = (select case from table18 where pin = 123);
Aquí está mi esquema:
(Perdone el mal diseño, es de una base de datos creada hace 20 años, no hay claves externas)
-Table18 (pin (PK), caso, officeNum, isVeteran)
-Table1 (case (PK), caseOfficer, streetAddress, apartmentAddress, cityAddress, stateAddress)
-Table5 (pin (PK), streetAddress, apartmentAddress, cityAddress, stateAddress)
-Table55 (rfa (CompositeKey), seqNum (CompositeKey), rfaAddress, streetAddress, apartmentAddress, cityAddress, stateAddress)
-Table103 (case (CompositeKey), histCode (CompositeKey))
-Table715 (caso (CompositeKey), histSeqNum (CompositeKey), histCode (CompositeKey), teléfono, correo electrónico)