Joined Records on report

[LOUM]

Good Day Everyone.

I have two quriers joined on the product code:
Query: VJoin has the following in it - Product Code, Warehouse, Vendor Code, Vendor Name
Query: Query1 has the following in it - Product Code, Description, QTY, Cost, Margin and such

I joined them so I could add the vendor name to my data set in Query1. I have tried multiple cardinalities on the join but seem to still pull in all my vendor names regardless of if there is an product or not.

Currently is have it set like this:
Each "Vjoin" has zero or more "Query1" (outer join) This has all products in the product master, most wont be in the data set of the report.
Each "Query1" has one and only 1 "VJoin"

Any ideas or comments are approeciated. Hopefully I have enough detail listed.

[ej]

I suggest you take a look at the underlying SQL that is generated.  You haven't said if the two queries themselves contain fields from more than one table which could cause additional data to be pulled in.  Do you know how the tables in the underlying model are joined? 

[ravimahazan84]

hi Loum,

If you need to join these table with data which exiting in bpth wt you can do u can use one-one join using product code it would be great if u can furnish more detail about your columns data .