I need help creating a view

[rarubio1]

Here is the problem, I have the exact same table, “tblParts”, that lives in two different databases. The only difference is that one database holds manufacturing info for secured parts and the other one holds manufacturing info for general parts. I want to create a view that lists part information for both. The view should look like the following:

Part # Secure
ABC123 1
DEF456 0
DEF123 0
GHI876 1

Please help, thanks in advance,
RR

 

[developer155]

ok, just join the tables. Use part# or any other primary key. If the databases are on the same server you can use db1..table1 and db2..table2 to reference them.