I have two tables, which i need to run a query against to extract a distinct list from.
The tables are as follows:
Im trying to figure out the query syntax to allow me to get a distinct list of sizes (small/large/XL) where the txtVariant in tblProductVariants = Size
I will also need to do the same for colours, whereby i need a distinct list of colours where the txtVariant = Colour.
Can anybody help?