SQL Question (Return a value if none exists).

[system]

@Sandy Smyth

you really need to be able to outer join both the customer ID from the customer table and the item ID from the TrafficCardItem table and you can’t have outer joins coming from two different tables joined to the CustomerValues table.

Acutally you can, but not with the standard BO setup for SQL server. You need the ANSI join syntax to do it, to get BO to generate the sql that way, you need to modify your PRM file.

LEFT_OUTER= 
RIGHT_OUTER= 
OUTERJOINS_GENERATION=ANSI_92 

See https://bobj-board.org/t/19226/3

---

Scott Bowers (BOB member since 2002-09-30)