------=_NextPart_000_007F_01CB8FB1.765BEB70
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
I have tables:
CREATE TABLE `tblNames` (
` IdName` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(60) DEFAULT NULL,
PRIMARY KEY (`IdName`),
) ENGINE=MyISAM
CREATE TABLE `tblStatusy` (
`IdStatus` int(11) NOT NULL AUTO_INCREMENT,
`IdName` int(11) DEFAULT NULL,
`Status` varchar(60) DEFAULT NULL,
`Data` datetime DEFAULT NULL,
PRIMARY KEY (`IdStatus`),
KEY `ixIDName` (`IdName `)
) ENGINE=MyISAM
How to get result which will be look like this:
tblNames.Id, tblNames.Name, (subquery which will return tblStatusy.Status,
tblStatusy.Data ordered by Data DESC LIMIT 1), (subquery which will return
tblStatusy.Status, tblStatusy.Data ordered by Data DESC LIMIT 1,1),
(subquery which will return tblStatusy.Status, tblStatusy.Data ordered by
Data DESC LIMIT 2,1)
Any idea how to get this?
Best regards
------=_NextPart_000_007F_01CB8FB1.765BEB70--
