Schalk Neethling wrote:
Mathias/Everyone on the list
I am running the following query against the database:
SELECT demographic.demographic_no, demographic.first_name,
demographic.last_name, demographic.chart_no, demographic.sex,
demographic.year_of_birth, demographic.month_of_birth,
demographic.
6.col
and T1.col=T6.col
[and col='val']
Doesn't this work ? Have you an example ?
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: Schalk Neethling [mailto:[EMAIL PROTECTED] Sent: lun
#x27;t this work ? Have you an example ?
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: Schalk Neethling [mailto:[EMAIL PROTECTED]
Sent: lundi 25 avril 2005 00:52
To: mysql@lists.mysql.com
Subject: j
Try this
If something is numeric
SELECT * FROM table1, table2, table3, table4, table5, table6
WHERE table1.something = table2.something
AND
table1.something = table3.something
AND
table1.something = table4.something
AND
table1.something = table5.something
?
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: Schalk Neethling [mailto:[EMAIL PROTECTED]
Sent: lundi 25 avril 2005 00:52
To: mysql@lists.mysql.com
Subject: joining six tables by mutual column
Greetings everyone.
Hope s
On Sun, April 24, 2005 3:51 pm, Schalk Neethling said:
> Hope someone can give me some pointers here. I have six tables in the
> database and I need to JOIN them on a row that appears in all of the
> tables. How do I do this? I have so far done the normal 'cross-join'
> saying SELECT * FROM table1,
Greetings everyone.
Hope someone can give me some pointers here. I have six tables in the
database and I need to JOIN them on a row that appears in all of the
tables. How do I do this? I have so far done the normal 'cross-join'
saying SELECT * FROM table1, table2, table3, table4, table5, table6
