Jimmy Cruyplants on 16 Jan 2019 21:38:14
I had two tables: one with product and international product. and the other one with brand name and alias name. I had to create a link between them by testing first if the product is matching the brand, where i didnt found any result then the product is matching the alias name then etc. It means that i had 4 links between 2 tables but i wanted to be able to test the first link on first priority, then second etc. There is no option for this when in SQL this is simple. Hopefully i found a solution but this is not very clean.