Hi!

I have Table 'user':
id = 1, name = John
id = 2, name = Peter
id = 3, name = Adam

Table 'usertofolder':
fkuserid = 1, fkfolderid = 3

Table 'folder':
id= 2, foldername = 'folderB'
id = 3, foldername = 'folderA'

I want to have a select statement to list all the names in table 'user' and the name for folder.id = 3.

Eg:
John, folderA
Peter, null
Adam, null

Is that possible?

Thanks.