CODEWITHSUNDEEP
sqlsql-server-2008
Jefferson Inoc
Jefferson Inoc

Reputation: 13

select from 2 tables where it has the same value or not depending on the search value

I wanted to search a value from 2 tables even it has the same column value or not.

e.g

Table 1

ID Name

1 Jump^Eer
2 Mouse
3 M^3ou^2ses
4 NiceMo^7use
5 ^2Pa^1p^7er
6 MickyMouse
7 JerryMouse

Table 2

ID Name

1 Jumper
3 Mouses
4 NiceMouse
5 Paper

Searching for value "Mouse"

Result will be

2 Mouse
3 Mouses
4 NiceMouse
6 MickyMouse
7 JerryMouse

Upvotes: 0

Views: 38

Answers (1)

Gubr
Gubr

Reputation: 324

select ID, [Name] from Table1 where Lower([Name]) like '%mouse%'
union
select ID, [Name] from Table2 where Lower([Name]) like '%mouse%'

Upvotes: 1

Related Questions