>>>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?
>>
>>Open the program (using MODI COMM (_GENXTAB)). The comments at the beginning of the file have a description of what parameters, their order, and defaults. You don't have to generate a cursor or table with just three columns. This should give you the information you need to solve your problem.
>>
>>hth,
>>
>>George
>
>Sorry, I don't get you. I know the VFPXTAB parameters. I can of course specify whichever field I want. However my problem is because of the data, not because of field in the input table. I cannot find a SQL statement that can JOIN the three tables and yet does not give me any NULL on the row or column field.

Sorry, misunderstood the question.

First, if you want to completely eliminate the NULLs then simply do the query on the table with Width, Substance and Weight or send that table, passing the appropriate parameters to VFPXTAB. This may mean, however, that some width items or substance items are missing. If you want them all, then may have to put up with some rows or columns with no value.

George