SQL EXCEPTION JOIN
I have three files (orderinfo, deliveryinfo and itemlines). The three files entries shall exist as 1 to 1 to many. The files contains orders from 10+ years. Thus data has been migrated several times by various people. I have discovered that the one-to-one-to-many rule has been broken for many orders. I wrote a pgm to [...]

Answer Question   |  May 4, 2010  1:01 AM
SQL, SQL Exception, SQL EXCEPTION JOIN, SQL join

Using Right() inside SQL Join
I need to join two tables where one table uses 0809 as data in the field and the other table uses 200809. Can this be done? Can I use a Right() statement in the join? Thanks

Answer Question   |  December 16, 2009  3:14 PM
MySQL functions, RIGHT JOIN, SQL join