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':
> +---