Hi. This is an example to explain my question. didnt put primary or foreign keys to make the example code more clean.create table myColumn( colId int, colName varchar(30))create table myRow( rowId int, rowName varchar(30))create table myTable( tableId int, tableAuthor varchar(30))create table myValues( colId int, rowId int, quantity int)
i want to build get registers in form of a table (with a select) likerowName1 | quantity_for_col_id1 | quantity_for_col_id2 | quantity_for_col_id3 .....rowName2 | quantity_for_col_id1 | quantity_for_col_id2 | quantity_for_col_id3 .....rowName3 | quantity_for_col_id1 | quantity_for_col_id2 | quantity_for_col_id3 .....RowName4 | quantity_for_col_id1 | quantity_for_col_id2 | quantity_for_col_id3 .....note that table myValues only has registers when quantity has a value.Lets say col1 col2 col3row1 23row2 row3 73
only row1,col1 = 23 and row3,col2 = 73 will be saved as registers in myValue table.So in the select i cant putSelect col1 col2 col2 from ...
because col1,col2,... are variable, they are in the table columns.any help on this, i just cant do it, been trying two days 
select variable fields
Posted - 2010-12-10 : 16:16:38
