I need Help writing what I thought would be a simple IF ELSE statement. I have a table called invoices that has the columns doc_no, bill_code, ship_code, and I want to select bill_code if ship_code isnull, Else ship_code if there is a value. Next, I want to use the value from this field to create an inner join to a table called addresses in which the primary key is address_code