Hi
Need help converting the following query to mysql
SELECT tabWORKORDER.INVOICE
FROM tabBILLCODESB INNER JOIN (tabBILLCODES INNER JOIN (tabWORKORDER LEFT JOIN
tabBILLING ON tabWORKORDER.INVOICE = tabBILLING.INVOICE) ON tabBILLCODES.CODE =
tabWORKORDER.BILLCODE) ON tabBILLCODESB.CODE = tabWORKORDER.BILLCODE
WHERE (((tabWORKORDER.PICKEDUP)="IsNull") AND ((tabBILLCODES.REQPURCHASEDATE)=T
rue) AND ((IsNull([tabWORKORDER].[PURCHASEDATE]))=True) AND ((tabBILLCODESB.TYP
E)=[tabBILLING].[TYPE])) OR (((tabWORKORDER.PICKEDUP) Is Null) AND ((tabBILLCOD
ESB.TYPE)=[tabBILLING].[TYPE]) AND ((tabBILLCODES.REQSOLDBY)=True) AND ((IsNull
([tabWORKORDER].[SELCODE]))=True)) OR (((tabWORKORDER.PICKEDUP) Is Null) AND ((
tabBILLCODESB.TYPE)=[tabBILLING].[TYPE]) AND ((tabBILLCODES.REQDEALER)=True) AN
D ((IsNull([DEALCODE]))=True)) OR (((tabWORKORDER.PICKEDUP) Is Null) AND ((tabB
ILLCODESB.TYPE)=[tabBILLING].[TYPE]) AND ((tabBILLCODESB.REQCODE)=True) AND ((I
sNull([tabBILLING].
))=True)) OR (((tabWORKORDER.PICKEDUP) Is Null) AND ((
tabBILLCODESB.TYPE)=[tabBILLING].[TYPE]) AND ((tabBILLCODESB.REQCONTNUM)=True)
AND ((IsNull([tabBILLING].[CONTNUMBER]))=True)) OR (((tabWORKORDER.PICKEDUP) Is
Null) AND ((tabBILLCODESB.TYPE)=[tabBILLING].[TYPE]) AND ((tabBILLCODESB.REQAU
TH)=True) AND ((IsNull([tabBILLING].[AUTHORIZATION]))=True)) OR (((tabWORKORDER
.PICKEDUP) Is Null) AND ((tabBILLCODESB.TYPE)=[tabBILLING].[TYPE]) AND ((IsNull
([tabWORKORDER].[SERIAL]))=True)) OR (((tabWORKORDER.PICKEDUP) Is Null) AND ((t
abBILLCODESB.TYPE)=[tabBILLING].[TYPE]) AND ((IsNull([tabWORKORDER].[MODEL]))=T
rue)) OR (((tabWORKORDER.PICKEDUP) Is Null) AND ((tabBILLCODESB.TYPE)=[tabBILLI
NG].[TYPE]) AND ((tabBILLCODESB.REQREINV)=True) AND ((tabWORKORDER.REINV)=0));