czupet
-
Posts
26 -
Joined
-
Last visited
Community Answers
-
czupet's post in JasperReports Server database was marked as the answer
I have found this info
http://community.jaspersoft.com/wiki/repository-resource-permission
-
czupet's post in Inner Join more then 1 table with MS ACCESS database was marked as the answer
Here's the correct syntax if anyone is interested.
SELECT
ContactsTable.`RecordID`,
ContactsTable.`ScanType`,
ContactsTable.`MillNumber`,
ContactsTable.`MachineNumber`,
ContactsTable.`Contact`
FROM
(`ContactsTable` ContactsTable INNER JOIN `ContactsTable` i ON ContactsTable.`RecordID` = i.`RecordID`)
INNER JOIN `ContactsTable` o ON ContactsTable.`RecordID` = o.`RecordID`