Some tables are linked more than one way - ambiguity.

[Thorsten Hohage]

Hi,

when trying to execute this query

select tr_project_suit_item.idserial, tr_project_suit_item.quantity,  
tr_article_stock_change.change_quantity
from  tr_project_suit_item, tr_article_stock_change,  
tr_super_sub_article, tr_super_article
where
tr_article_stock_change.parent_class = 'TRClothSub' and
originate_class_name = 'TRProjectFolder' and

tr_super_sub_article.idserial = tr_article_stock_change.parent_serial  
and
tr_super_article.idserial = tr_super_sub_article.parent_serial and
tr_article_stock_change.originate_serial =  
tr_project_suit_item.parent_serial and
tr_super_article.idserial= tr_project_suit_item.article_id and
tr_super_sub_article.sub_id = tr_project_suit_item.sub_id

I got a "Some tables are linked more than one way - ambiguity. " while  
this


select tr_project_suit_item.idserial, tr_project_suit_item.quantity,  
tr_article_stock_change.change_quantity
from  tr_project_suit_item, tr_article_stock_change,  
tr_super_sub_article, tr_super_article
where
tr_article_stock_change.parent_class = 'TRClothSub' and
originate_class_name = 'TRProjectFolder' and

tr_super_sub_article.idserial = tr_article_stock_change.parent_serial  
and
tr_super_article.idserial = tr_super_sub_article.parent_serial and
tr_article_stock_change.originate_serial =  
tr_project_suit_item.parent_serial and
concat(tr_super_article.idserial,'_',tr_super_sub_article.sub_id) =  
concat(tr_project_suit_item.article_id,'_',tr_project_suit_item.sub_id )


works like expected. But IMHO they are form the "linking" side the  
same logic?


regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany