3 Replies Latest reply: Jun 2, 2009 9:17 PM by John Witherspoon RSS

    Left join referencing fields in both tables


      Hi all,

      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,