General information
Category:
Coding, syntax & commands
I have three tables. One stores all available 'Width'. One stores all available 'Substance'. One stores the transaction with 'Width', 'Substance', and 'Weight'. How do I generate a crosstab with the following look with 'Weight' as the content?
Subs1 Subs2 ......
Wdth1
Wdth2
..
..
..
My transaction may not have all the widths and substances. I tried using FULL JOIN but it gives me an extra NULL row and an extra NULL column. Is there a way I can get rid of the NULL row and the extra NULL column. (the NULL row and column arise because the transaction does not have all the available widths and substances)
Any idea?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only