different

How to fetch data from two different sql servers?

Hi, I have an inline query, in which I have one table1 in server1 and another table2 in server2. I need to join these two tables, and fetch data. I can do this like connect to one server, get data and connect to next server...fetch data. and join them. But is there any other better way. I have heard about Linked servers. Will that hel...

Using sql tables with the same name on different schemas

Hi, Does anyone know of any white papers available that discuss the use of tables with the same name existing on different schemas? I'm implementing on SQL Server but I imagine the theory can be applied to any RDBMS. Thanks, Gary ...

Two different destination of submit in one form

Hello all, i have one form which need to submit data into two different tables in same DB. at past time, i have asked how to submit form into two tables, but it impossible. Then, I try to submit this form use two submit buttons with different destination. Could you give some advise to submit this form after click them? ...

putting records in new table that don't have 6 or more different addresses for same name - Microsoft Access

Hey all, If the names repeated is more than 6 and there are six different addresses for that same name, then I don't want to output them to the KeepThese table: harry baker 1 street harry baker 2 street harry baker 3 street harry baker 4 street harry baker 5 street harry baker 6 street donald ross 11th street So harry baker should be...

SQL database queries basic question AVG Difference

I have a really basic question on SQL. Relational Schema: Student (Sid, Sname ) Class (Sid, ClassName, mark) ClassName = { MATH, ENGLISH, PHY, .......} I want to list out all the student who have taken MATH, and their MATH class average minus the student's math mark Select DINSTINCT S.Sname, (E.Mark - AVG (E.Mark)) From Student ...