Ok, if you got this far you must have an idea what im looking for. I have two DB's. I need to query four columns in two tables in two DB's at the same time to produce a list of info in order of address(last part I can do )example: DB1 has table "customers" with columns, address,cust number, phone. second DB2 has table "site", with columns cust number, amount owed, unique code, last bill date. I need to reference the customer number in both to match to get a result containing, "customer number, address, unique code, and amount owed.
sound easy to anyone?
most database systems support (some subset of) standard SQL, so no, you aren't necessarily in the wrong forum, however, there are often significant differences in the variants of SQL from one database system to another
in this case, SQL Server requires the owner name between the database name and the table name, or, at least, requires the missing period