mercredi 11 février 2015

Joining tables with different column name but same value in sqlite

I'm using SQLite to work with my database


I have two different tables, with key columns that have different names but the same value.


As such:



shoes
Identification | Name | Shoe size
1 Bob 10
2 John 12


payment
PaymentID | Price | Year
1 20 2013
2 38 2015


I need



Identification(or PaymentID, no matter) | Name | Shoe size | Price | Year
1 Bob 10 20 2013
2 John 12 38 2015


I've been searching, and trying to understand the tutorials to no avail. I guess im just too stupid


Aucun commentaire:

Enregistrer un commentaire