I am trying to make a view in SQL server that takes data from two diferent databases. The two tables are exaclty the same and what i need it is a union between them.
The query designer doesn't allow me to do so, so I'm wondering wether this is possible or not.
any clues
.......
DO WHILE .T.
ME.Work()
ENDDO