[Typo3-dev] database relations in TYPO3

[Dmitry Dulepov]

Hi!

Ries van Twisk wrote:
> select * from sometable where uid in
>         (select relation_field from anothertable)
> 
> The above query is not even possible with typo3 because of that blob
> field and 'virtual' relations.

I do not see a problem. For example, why you can do this:
	select * from sys_filemounts where uid in
		(select file_mountpoints from be_user
			where username='admin')

file_mountpoints is a comma separated list of values (usually UIDs).
Same applies for other fields. Even if it is blog, it still selects
comma-separated list of values.

Dmitry.