Dear all,
thank you very much for the fast and numerous responses. The idea of Roger
Baklund does exactly what I want. Thank you very much Roger.
I oversee the possibility to use IF conditions on MySQL server, this is what
I wanted to do programmatically but to do in the DB server is ok. Let's s
on 12/29/03 12:00 PM, Bjoern Wuest wrote:
> Hello
>
> I have the following problem:
>
> Table1 'pl':
> +---+---+
> | p | o |
> +---+---+
>
> Table2 'ln':
> +---+--+---+
> | p | l | v |
> +---+--+---+
>
> Now my problem: how to write a statement to select all 'p' and 'v' from 'pl'
>
* Bjoern Wuest
> I work on this problem for three days now and could not find any
> tip in any manual, book, tutorial or search engine.
>
> I have the following problem:
>
> Table1 'pl':
> +---+---+
> | p | o |
> +---+---+
> | 1 | 1 |
> | 2 | 1 |
> | 3 | 2 |
> +---+---+
>
> Table2 'ln':
> +---
Hello
I work on this problem for three days now and could not find any tip in any
manual, book, tutorial or search engine.
I have the following problem:
Table1 'pl':
+---+---+
| p | o |
+---+---+
| 1 | 1 |
| 2 | 1 |
| 3 | 2 |
+---+---+
Table2 'ln':
+---+--+---+
| p | l | v |
+---+--+
