CODEWITHSUNDEEP
hibernatehql
yed2393
yed2393

Reputation: 271

Like query on 2 columns

I would like to have a like query on 2 columns on 2 different tables.

Lets say Table Product and Table DefectProducts have columns of SerialNumber. I want my query work for like below case.

For example SerialNumber from Product table is NS123 and SerialNumber from DefectProducts is SNS123. I want to get that SNS123 value.

Original query: 
select dp.SerialNumber from Product p, DefectProducts dp where p.SerialNumber=dp.SerialNumber

Desired Query:
select dp.SerialNumber from Product p, DefectProducts dp where p.SerialNumber like %dp.SerialNumber%

Upvotes: 0

Views: 33

Answers (1)

Simon Martinelli
Simon Martinelli

Reputation: 36103

A UNION with SQL would look like this

select SerialNumber from (
    select p.SerialNumber from Product p
    union all 
    select dp.SerialNumber from DefectProducts dp
) as x
where x.SerialNumber like = ?

Upvotes: 1

Related Questions