I'm working on a sql statement that fails in a very strange way.
When I do this:
select * from database.matches where sku = '02_SM11'
I get a list of matching records.
When I do this:
select * from database.products join database.matches on products.sku = matches.sku and matches.related = '02_SM11'
no records are returned.
If the search is on any other sku (other than those starting with 02), I get a list of matching records.
At first I thought the underscore was my problem, but replacing it with an alpha character has no effect.
Yes, there is a record for 02_SM11 in the products table.

Anybody have any thoughts on what's happening here?


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>