Problem to select data via JOIN with many tables

[Pieter Vdb]

Hi,

Following database structure:

CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`personsId` int(11) NOT NULL,
`typeId` int(11) NOT NULL,
`username` varchar(100) NOT NULL,
`password` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=225 ;

CREATE TABLE `schools` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`namem` varchar(100) NOT NULL,
`director` varchar(150) NOT NULL,
`mailadres` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

CREATE TABLE `users_schools` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usersId` int(11) NOT NULL,
`schoolsId` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=225 ;

CREATE TABLE `lessons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`schoolsId` smallint(6) NOT NULL,
`date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=239 ;

CREATE TABLE `persons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`address` varchar(100) NOT NULL,
`email` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=283 ;

CREATE TABLE `points` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`lessonsId` int(11) NOT NULL,
`usersId` int(11) NOT NULL,
`score` double NOT NULL,
`remark` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

CREATE TABLE `type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`level` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

I want a view to make a list with name (table persons), score and remark (table points) for all persons who have a record in table Users.
I want to specify also a specific school and lesson.

Can someone help me? Via Google I found many examples for JOIN query's, but no one with so many tables.

Pieter