Displaying 1 result from an estimated 1 matches for "53e57e4b".
2006 Jul 18
5
SQL query question
Hello,
I know it''s off-topic. But I''m sure you are using SQL and can help me ;)
I''ve a table CARS and a table KEYS and a LOCKS table.
CARS
id|name
1|audi
2|ford
3|mazda
4|porsche
...
KEYS
id|car_id|lock_id
1|1|1
2|2|1
3|2|2
4|3|1
5|3|2
6|4|1
7|4|2
8|4|3
...
LOCKS
id|name
1|main
2|spare
3|engine
...
A car can have many keys. Keys are for different locks.
How can I