RE: Query problem: UNION in subquery

2006-05-24 Thread Neeraj
FROM form15 f15 WHERE f15.Form15SampleTube6RnaBarcode IN ('01D2V','01DH6'))as abc Cheers :) Neeraj Black Bits -Original Message- From: Luke [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 9:36 AM To: mysql@lists.mysql.com Subject: Query problem: UNION in subquery Hello! I

Re: Query problem: UNION in subquery

2006-05-24 Thread Luke
]; mysql@lists.mysql.com Sent: Wednesday, May 24, 2006 2:16 AM Subject: RE: Query problem: UNION in subquery Hi Luke.. Try this SELECT ObjectId FROM (SELECT f15.Form15SampleTube1RnaBarcode AS ObjectId, f15.Form15PatientID AS PtId FROM form15 f15 WHERE f15.Form15SampleTube1RnaBarcode

Query problem: UNION in subquery

2006-05-23 Thread Luke
Hello! I have a problem using UNIONs inside subqueries. I have simplified my query to make it more readable/understandable. The question is about the right syntax. 1. This works fine /UNION/ (SELECT f15.Form15SampleTube1RnaBarcode AS ObjectId, f15.Form15PatientID AS PtId FROM form15