How to use select in a table that is not related?

Navigation
-3

I need to build a SQL query that lists the amount to be paid per km, the quantity used and the total amount to be paid for each lease

It is a SELECT and inner / left join exercise but I do not know how to relate LOCATION to TABLE.

Thank you!

    
asked by anonymous 28.09.2018 / 15:43

1 answer

-1

I'll try to help you by what I understood from your question. In database we have the concept of primary key and foreign key, primary key is a unique identifier of a record of a table. The foreign key is a reference to the primary key of another table. Having a basic notion of this you can relate different tables through primary keys and foreign keys. And to help with the inner joins part I will leave the w3schools link link

    
28.09.2018 / 17:34
What's wrong? I use PyCharm Status of sale in C #