[SQL] Re: query on two databases ..

2001-06-05 Thread Muhammed Yazici
...sh* But thanx .. i'll try another solution .. "Nils Zonneveld" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Muhammed Yazici wrote: > > > > hi, > > i'am really new to postgresql a

[SQL] query on two databases ..

2001-06-05 Thread Muhammed Yazici
hi, i'am really new to postgresql and i try it with php .. Now i have following question : is it possible to make one query on two databases. I have a database calles db1 and one db2 and i want to get : select * from ":db1:table1" where ":db1:table1:col1" in (select "col1" from ":db2:table1"