ID FROM Table2 WHERE Source2_Name = 'name'
UNION
SELECT Main_ID FROM Table3 WHERE Source3_Name = 'name'
-Original Message-
From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Sent: Monday, July 27, 2009 1:09 PM
To: mysql@lists.mysql.com
Subject: Re:
¢ndido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Sent: Monday, July 27, 2009 1:09 PM
To: mysql@lists.mysql.com
Subject: Re: SELECT query question
select
*
from
MainTable MT
left join Table1 T1 on MT.Main_ID = T1.MainID
left join Table2 T2 on MT.Main_ID = T2.MainID
left join Table
select
*
from
MainTable MT
left join Table1 T1 on MT.Main_ID = T1.MainID
left join Table2 T2 on MT.Main_ID = T2.MainID
left join Table3 T3 on MT.Main_ID = T3.MainID
where
T1.Source1_Name = "anything" or
T2.Source2_Name = "anything" or
T3.Source3_Name = "anything"
Not tested.
-
Luis Lebron wrote:
I have a test results table that looks like this
student_id test_id score
1 1 90
1 1 100
1 1 80
2 1 95
2 1 85
2
n" <[EMAIL PROTECTED]>
To: "Jon Rosenberg" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 1:48 PM
Subject: RE: select query question
> create temporary table foo as select patientnumber, count(*) as rcount
> from source_table
> grou
create temporary table foo as select patientnumber, count(*) as rcount
from source_table
group by patientnumber
having count(*) > 1;
select count(*) from foo;
-Original Message-
From: Jon Rosenberg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 1:29 PM
To: [EMAIL PROTECTED]
Sub