I am looking to do something I'm not even sure is possible, say I have the following table
ID Part Setting Shop
1 A 1
2 B 2
3 B 1.5 B
4 C 3
5 D 4
I am trying to find a query that will allow me to select all unique part type settings, but if I pass in a shop I will get the specific part for that shop.
So default would be
ID Part Setting Shop
1 A 1
2 B 2
4 C 3
5 D 4
But if I send in WHERE SHOP = B
then the result would look like
ID Part Setting Shop
1 A 1
3 B 1.5 B
4 C 3
5 D 4
Aucun commentaire:
Enregistrer un commentaire