ok...here's the thing, i've been trying to join two queries in one but i'm not getting any results, maybe i'm doing it wrong i don't know
here are the queries:
select tbEntidadesMoradas.codEntidade, Entidades.Entidade, Moradas.Morada, Moradas.CodPostal, Moradas.Localidade FROM Entidades INNER JOIN tbEntidadesMoradas ON Entidades.CodEntidade = tbEntidadesMoradas.codEntidade INNER JOIN Moradas ON tbEntidadesMoradas.codMorada = Moradas.codMorada
the other one
select tbEntidadesAltContact.codEntidade, tbEntidadesAltContact.codAltContc, ContactosAlternativos.Nome, ContactosAlternativos.Morada, ContactosAlternativos.Contacto FROM tbEntidadesAltContact INNER JOIN ContactosAlternativos ON tbEntidadesAltContact.codAltContc = ContactosAlternativos.codConAlt
what i want is to join them or re-arrange them for the outup of the two of them to be only one..
thanks in advance
Can you not use a union? Now do the queries relate to each other.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment