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???

Report message to a moderator

Previous Topic: question bank
Next Topic: TOP & ROWCOUNT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:44:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.