This may be a stupid question, but for some reason I can’t remember or seem to be able to find if you can concatenate objects from two different tables into one object. It seems like there wouldn’t be a problem, however when I concatenate columnA.Table1 with columnB.Table2 I get a cartesian product on that object alone. The object at first had no where statement, but then I put one in there and it created two identical where statements in the SQL. I updated the object again and got a valid SQL statement with one where statment joining the two tables and I still get a Cartesian product. Does anyone have any suggestion or references to a previous entry on this?
The tables are definitely joined. I have added the join in the Where statement of the object itself so that it uses the join. Otherwise the objects would return a SQL statement with no Where statement. I can send you the SQL if you would like.
SELECT
(ohmemb.dbo.member_group_product_mbrgp.mbrgp_primary_sid)+
((ohmemb.dbo.member_mbr.mbr_gender_code) )
FROM
ohmemb.dbo.member_mbr,
ohmemb.dbo.member_group_product_mbrgp
WHERE
( ohmemb.dbo.member_group_product_mbrgp.mbrgp_member_eid = ohmemb.dbo.member_mbr.mbr_member_eid )