This content has been marked as final. Show 3 replies
is it possible to do a join in QV while, at the same time referencing fields from both tables?
Let's say i have table A and table B. I'm left joining table B to A using key field [EntryNo], but only where [InvovicedQuantity] in table A is <> 0. Is the possible to do that in one join?
Or do I have to join first and than resident load from A while putting 0 or Null in the joined fields where InvoicedQuantity is 0?
Thanks for your help,