i would like to put multiple condition inside a join. I have two tables.
Table a
Name | Color | Type | Price
A Red Apple 2
B Blue Pear 3
C Violet Orange 4
Table b
Name | Color | Type | Price
A Red Apple 2
B Blue Pear 1
C Violet Banana 4
I need to know when a.name = b.name AND color is the same or not, type is the same or not, price is the same or not, and all other combination (color and type are equals, price no, ecc.)
How can i do that in sqlite? Thanks in advance
Aucun commentaire:
Enregistrer un commentaire