Re: [PHP] including the result of one query in another query

2005-06-30 Thread Richard Lynch
On Sun, June 26, 2005 3:38 am, Pedro Quaresma de Almeida said: > I have two databases, on for aeromodelistas (aeromodelling) and > another for Códigos Postais (Postal Codes). I whant to do the > following query First, MySQL *DOES* allow you to select from multiple databases in a single query. Mos

Re: [PHP] including the result of one query in another query

2005-06-30 Thread Richard Lynch
On Sun, June 26, 2005 4:53 am, Brian V Bonini said: > On Sun, 2005-06-26 at 06:38, Pedro Quaresma de Almeida wrote: >> Hi >> >> I have two databases, on for aeromodelistas (aeromodelling) and >> another for Códigos Postais (Postal Codes). I whant to do the >> following query >> >> SELECT CódigoPost

Re: [PHP] including the result of one query in another query

2005-06-27 Thread Burhan Khalid
Pedro Quaresma de Almeida wrote: Hi I have two databases, on for aeromodelistas (aeromodelling) and another for Códigos Postais (Postal Codes). I whant to do the following query SELECT CódigoPostal FROM Aeromodelistas WHERE CódigoPostal IN (SELECT distinct(CP4) FROM codigopostal.LOCART,codi

Re: [PHP] including the result of one query in another query

2005-06-26 Thread Jasper Bryant-Greene
Jochem Maas wrote: >> I have two databases, on for aeromodelistas (aeromodelling) and >> another for Códigos Postais (Postal Codes). I whant to do the > > what DB are you using? MySQL? > you can't select across multiple DBs in any RDMS that I know of ... > so it looks like either use 2 queries or

Re: [PHP] including the result of one query in another query

2005-06-26 Thread Brian V Bonini
On Sun, 2005-06-26 at 06:38, Pedro Quaresma de Almeida wrote: > Hi > > I have two databases, on for aeromodelistas (aeromodelling) and > another for Códigos Postais (Postal Codes). I whant to do the > following query > > SELECT CódigoPostal FROM Aeromodelistas > WHERE CódigoPostal IN > (SELEC

Re: [PHP] including the result of one query in another query

2005-06-26 Thread Jochem Maas
Pedro Quaresma de Almeida wrote: Hi its not a php question. I have two databases, on for aeromodelistas (aeromodelling) and another for Códigos Postais (Postal Codes). I whant to do the what DB are you using? MySQL? you can't select across multiple DBs in any RDMS that I know of ... so it

[PHP] including the result of one query in another query

2005-06-26 Thread Pedro Quaresma de Almeida
Hi I have two databases, on for aeromodelistas (aeromodelling) and another for Códigos Postais (Postal Codes). I whant to do the following query SELECT CódigoPostal FROM Aeromodelistas WHERE CódigoPostal IN (SELECT distinct(CP4) FROM codigopostal.LOCART,codigopostal.DISTRITO WHERE codigopo