JiggiezBok
New Member
I have to choose the according column to join basing on a value that can be null.In detail:\[code\]SELECT shoporders.orderid, shopaddresses.companyname, shopaddresses.firstname, shopaddresses.lastname, shopaddresses.address1, FROM shoporders INNER JOIN shopaddresses ON shoporders.InvoiceAddressId = shopaddresses.addressidwhere orderid = 110order by shoporders.createddate desc\[/code\]if shoporders.InvoiceAddressId is null then I have to use shoporders.DeliveryAddressIdAny clue?Thanks in advance