Union Queries and Linked Views in MSSQL

  • Thread starter Thread starter Werner van Zijl
  • Start date Start date
W

Werner van Zijl

Are Union Queries the same as linked Views to MS SQL? If
not, what is the difference and advantages of either? How
can I get a linked View to limit the number of records it
displays in an MDB?

Thank you for your help!

Werner
 
They are different thing.

A linked view is just a pointer to a query stored on the SQL Server

A union query is a type of query that appends the results of 1 select
statement to the end of another. Have a look at Northwind for the example
query called "Customers and Suppliers by City"
 
Back
Top