Re: [midgard-user] sql question, midgard related

[Tarjei Huse]

> A quick way to find orphaned articles:
> SELECT article.id,article.author FROM article LEFT JOIN person ON
> article.author=person.id WHERE person.id is NULL
Emile, I think you have just become my ethernal hero!
Thanx
Tarjei
> Emile
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]