Hi ,
Can anyone help me in this regard.
I have two tables.
1st table - all the values are in columns ( Parent Table )
2nd table - all the values are in rows ( Child Table) ie Attributes are in rows.
I would like to to know how the relationship and query subject can be created.
Thanks
I don't think you can solve this problem with a simple relationship. You need to pivot the values in parent table from columns to rows in your data layer.
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx
http://www.oracle-base.com/articles/11g/pivot-and-unpivot-operators-11gr1.php
Thanks John!
I wonder if the pivot works..because all the values are in rows ( Child Table) ie Attributes are in rows.
In your case, you need to use UNPIVOT on the parent table to move the values from columns to rows.
Thank you John :)