CODEWITHSUNDEEP
sql-serverdatabase
Emmanuel Vincent Nuestro
Emmanuel Vincent Nuestro

Reputation: 3

Inner-Join query is returning no data on sqlserver 2012

enter image description here

Trying to run a query which builds a list of reports that all have information stored about them from 3 different tables.

Upvotes: 0

Views: 61

Answers (2)

Allam Kalyana
Allam Kalyana

Reputation: 31

Please use '%' with LIKE

p.pdesc like 'CEL%'

p.pdesc like '%CEL%'

Upvotes: 1

Tarun Shrivastav
Tarun Shrivastav

Reputation: 26

Your query seems fine. Just a guess check you celphone spelling 'cellphone'

or you can debug like test with you first join is it returning the data or not then next join then check with your where clause.

Upvotes: 0

Related Questions