help newbee converting access query to php
Posted: Thu Apr 27, 2006 4:58 pm
Hi guys
Newbee here and newbee when it comes to php.
Need help converting a complex access query to put in php
I assume that the [] parenthesis have to be converted to () and "MEM10105" to 'MEM10105', but as for the rest.... its way over my head.
If someone is able to help me in the right direction, that would be most helpful.
Cheers
-Craig
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