Is there a fuction that I can use to concatenate two fields together that are coming from two different tables without having to do this within sthe cript? For example i want the filed(Concat Field) to be like below:
Where are you wanting to see the concatenated field? Srinivasan has already posted the syntax for creating the combined value. If you require it as a dimension in a chart you will need to 'Add Calculated Dimension'. There is no way of having the concatenated field in a list box or a table box in QV 9.0, but I believe you will be able to in QV 10.
If you want the field usage to be more robust dealing with it in the load script would be the best place to do the concatenation. Use of the JOIN statement with a RESIDENT load would probably be required.
