Hi folks... I can get this to work, but I dont think I am doing it properly (see the attached image for the SQL Data and the screen result).

I have the following select in the "Data" configuration area of the component:

SELECT
T1.virtuemart_product_id , T1.product_name , T1.product_s_desc , T1.product_desc , T2.product_price
FROM `wrf_virtuemart_products_en_gb` AS T1
INNER JOIN `wrf_virtuemart_product_prices` AS T2
ON T1.virtuemart_product_id = T2.virtuemart_product_id
ORDER BY T1.product_s_desc DESC

and in the columns table below I have tried to use the "T1. & the T2. prefix for the column names.
The data records select OK, but just dont display.

If I change the Select code to use the 'AS' construct (eg Select T1.product_description AS Decscription.. etc"), then everything works absolutely OK.

Can you tell me where I am going wrong????

Thanks,
Mike

Hello,

Use the following SQL query:



or



Regards,
ARI Soft

Thanks a amillion for your reply.... you have been a great help, and I truly appreciate i.


thanks again,
Mike