Posted by Jim Michaels on 01/09/06 10:38

if what found do what else what? I am not sure what you are getting at.
Guess i'll have to try to figure out what you are saying from scratch. (?)

"Juliette" <jrf_no_spam@jokeaday.net> wrote in message
news:43847a0e$0$89138$dbd45001@news.wanadoo.nl...
> The logic I am looking for is something along the lines of:
>
> SELECT tc.item_text
> FROM text_content as tc, text_items as item, available_languages as lang
> WHERE item.item_id = tc.item_id
> AND tc.lang_id = lang.lang_id
> AND item.approved <= CURDATE()
>
> AND IF FOUND (
> tc.lang_id = 002
> AND tc.approved <= CURDATE()
> AND lang.approved <= CURDATE()
> AND item.approved <= CURDATE()
> AND MAX(tc.translation_version)
> AND ( ( MAX(tc.item_version WHERE tc.lang_id = 001) - MAX(tc.item_version
> WHERE tc.lang_id = 002) ) < 2 )
> )
> ELSE (
> tc.lang_id = 001
> AND tc.approved <= CURDATE()
> AND lang.approved <= CURDATE()
> AND item.approved <= CURDATE()
> AND MAX(tc.translation_version)
> AND MAX(tc.item_version)
> )

• Next in forum: Re: Complicated subquery or join
• Prev in forum: Re: Complicated subquery or join
• Thread view: Re: Complicated subquery or join

[Reply to this message]