jeudi 16 juillet 2015

SQlite multiple table references

I'm not 100% sure I picked the correct title to this questions.. I've not done much work with SQlite or databases in general.

I'd have tried to google a solution if I knew what I needed to search!

So here's an example of what I want to achieve.

I have a Cars Table and a Workers Table, Cars Table is made up of carID, carName and I want to add a Workers field.. in this field I want to be able to list a number of workers that worked on the certain car.

The Workers table will be as follows - workerID, workerName, dateStarted, salary.

The idea is to list a certain car I.E carID: 1, carName: Ford Ka, workers[joe, bob, jim] and be able to access their individual properties?

Thanks, I'm not sure if this has been answered anywhere.

!!!!

Aucun commentaire:

Enregistrer un commentaire