Home » RDBMS Server » Server Administration » Search for fields in Multiple tables
Search for fields in Multiple tables [message #375264] Wed, 15 August 2001 15:34
lexar
Messages: 2
Registered: August 2001
Junior Member
Hi,

What is the most efficient way to write a SQL statement that will look for a value in the same column but multiple tables.
e.g. search for "Alex" in NAME column of table 1, table2, tables 3, etc...

I am think of that a multiple UNION ALL statement would do it but I am wondering if there is a better way???
Previous Topic: question bank
Next Topic: TOP & ROWCOUNT
Goto Forum:
  


Current Time: Tue Dec 24 10:34:43 CST 2024