Jay Blanchard wrote:
[snip]
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT CORCOL BLAH FROM tableC WHERE c1 = 'c' AND c2= 'c' );
[/snip]
This query is just badly formed, for instance, where is the table aliased 'b' in your from statement? Are you showing the complete query?
Here's the problem sql
SELECT 'SBC' FIN_RIC, BRAGG_ISS.* FROM BRAGG_ISS WHERE ARCHIVE_DATE >= DATE_SUB(CURDATE(),INTERVAL 5 DAY) AND SUBSTRING(DIC,1,2) = 'A5' AND SUBSTRING(DIC,3,1) <> 'J' AND MRO = 'I' AND RIC_STOR IN (SELECT RIC_STOR FROM DODAAF WHERE RIC_FIN_SP = 'SBC' AND CTASC = 'SBC' AND TYP_U_CD IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J'))
There's no "RIC_STOR" in the DODAAF table, the column is called "RIC"
changing the sql to this works fine
SELECT 'SBC' FIN_RIC, BRAGG_ISS.* FROM BRAGG_ISS WHERE ARCHIVE_DATE >= DATE_SUB(CURDATE(),INTERVAL 5 DAY) AND SUBSTRING(DIC,1,2) = 'A5' AND SUBSTRING(DIC,3,1) <> 'J' AND MRO = 'I' AND RIC_STOR IN (SELECT RIC RIC_STOR FROM DODAAF WHERE RIC_FIN_SP = 'SBC' AND CTASC = 'SBC' AND TYP_U_CD IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J'))
the bug is, the nested query on the first statement is ignored
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
