Newbee here and newbee when it comes to php.
Need help converting a complex access query to put in php
Code: Select all
SELECT fieldtable.Name, [unitstable]![Industry] & [unitstable]![FieldNo] & "." & [unitstable]![UnitNo] & [unitstable]![Version] AS UnitNumber, unitqual.QualID, unitstable.UnitName, unitstable.UnitWeight, unitstable.NoOfPathsB, unitqual!Mandatory Or unitqual!Stream Or unitqual!Optional Or unitqual!Optional2 Or unitqual!Optional3 AS Expr1
FROM (unitqual INNER JOIN unitstable ON unitqual.UnitID = unitstable.UnitID) INNER JOIN fieldtable ON unitstable.FieldNo = fieldtable.FieldNo
WHERE (((unitqual.QualID)="MEM10105") AND (([unitqual]![Mandatory] Or [unitqual]![Stream] Or [unitqual]![Optional] Or [unitqual]![Optional2] Or [unitqual]![Optional3])=True))
ORDER BY unitstable.FieldNo, unitstable.UnitNo;If someone is able to help me in the right direction, that would be most helpful.
Cheers
-Craig