Hi Travis
Thank you for the hint.
i yesterday found the following hint, which I then followed.
select t1.datum, t2.sdat. t3.tag from table as t1
left outer join table2 as t2 on t1.datum = t2.sdat
left outer join table2 as t3 on dayname(t1.datum) = t3.tag
Note: it does not work with inner j
On 9/7/2010 3:33 AM, Thorsten Heymann wrote:
Yes sure, but you will consider, it is more than a nice to have to let
the user know what field he filled incorrectly (e.g. in a
webform,...). And it would be nice to this in an automated way.
I have to agree. Due to database design issues that th
Does this work?
select *
from t1
join t2 on (t1.datum = t2.sdat or dayname(t1.datum) = t2.tag);
-Travis
-Original Message-
From: mysql [mailto:my...@ayni.com]
Sent: Tuesday, September 07, 2010 1:43 AM
To: mysql@lists.mysql.com
Subject: Conditional join of tow tables
Hi listers
mysql> s
Good day everyone
I think I have asked this question a while back but cant
remember whether I have received an answer yet so I will ask again.
I am busy studying for my MySQL certification exams,
however the only book I have available to me is the MySQL 4 manual.
Hello Jörg,
thanks for your detailed answer.
> I don't think it a good approach to scan error message texts for
> automated analysis in an application, this is a race which the
> application (developer) is bound to lose.
Yes sure, but you will consider, it is more than a nice to have to let the
Hi listers
mysql> show global variables like "version";
+---++
| Variable_name | Value |
+---++
| version | 5.1.46 |
+---++
1 row in set (0.02 sec)
mysql>
Following problem: Two tables which must be joined differently depending