Welcome Guest, Not a member yet? Register   Sign In
sql Like query doesn't work
#2

[eluser]stommert[/eluser]
Hi,

If you use a join of any kind (inner, left, right) and you have a delimiter on the table you are joining and there is no record for the joined field, there will be no results. witch is quite logick, if you consider that you can't have a delimiter on a non existing field.

I would debug this by removing the joins and take it one join at the time.
I hope this helps to solve your problem


Messages In This Thread
sql Like query doesn't work - by El Forum - 02-09-2010, 10:17 PM
sql Like query doesn't work - by El Forum - 02-10-2010, 01:37 AM



Theme © iAndrew 2016 - Forum software by © MyBB