I have a question that requires me to find the total profit for a month. For example I have two tables, one table transactions has the attribute agreedprice, the other table called car has an attribute called pricepurchased. How can I display these two tables side by side?
I've tried all types of joins however it's only giving me matching values between the two. I want to see the agreedprice and the pricepurchased in my SQL file, the price purchased never meets the agreedprice so for every statement I've done it only gives me one side.
Aucun commentaire:
Enregistrer un commentaire