Hi,

Please help me with the below query,

I know something is wrong with the query

select name, model, year, price, A.standard, A.optional, A.notes from ABC
WHERE standard <> NULL
AND (IF Standard= NULL THEN Optional) OR (IF Optional =NULL THEN notes)
order by name, model , year DESC

THANK YOU