I need a correct syntax for the statement above.
I know this is completely wrong.
But I think you'll understand the sense, so that you can help me to put it in a correct staement.
SELECT History.Date, History.Action, Customer.Name, Customer.Number, Vendor.Name, Vendor.Number
FROM History where (History.Membercode = Customer.Code) or (History.Membercode = Vendor.Code)
or History.Membercode =0
Thanks a lot!!