New to BIRT - Struggles with Data Join

maestro13

Ok,
I'm very new to BIRT and must be just missing something.
Have two tables...
1) is ITEM with keys of Org and itemID
2) is prodretail with keys of Org and prodretailid (alternate key on SKUid & ITemID)

What I'm trying to do is get my report to give me all items from the item table... where org is = ? (input)... (This part seems to work just fine)

And on the same line, I want the information from the prodretail table where the SKUid or ITEMid match what comes out of the item table.

The kicker is I need to put in one more table to boot, but I just think I'm having issues with setup on the joins, so will deal with that later.

Not sure the best way to give info to get assistance.

I have attached three screen shots...
One is the item edit data set
Two is the productretail data set
Three is the combo...
(Issue is here as what I really need is all records that match the input value of org... and matches either the skuID or ItemID from the item table.

I can write the SQL without a join, but not sure how I would do that in here as I can't seem to just write the SQL into the join.

Thanks in advance and if you need more info, please let me know.

Mark

maestro13

I am often getting results where in the preview results option of the join/edit data sets, my results will look fine, but when I place the item on the report and run it... using same input variables... I get repeating rows.
Just something more to add in.
Any thoughts are appreciated...
Mark