M
M
Mikhail Mashkantsev2021-06-13 17:58:14
SQL
Mikhail Mashkantsev, 2021-06-13 17:58:14

Error when trying to create view: 'car_number' column specified multiple times..?

The query works, but when creating the view, it says "the column "car_number" is specified repeatedly"
select * from done_cars inner join works on done_cars.car_number=works.car_number where works.number=( select number from works group by number order by count(number ) desc limit 1);

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
BorLaze, 2021-06-13
@ Michael_29

car_number is duplicated for you - done_cars.car_number and works.car_number
when creating a view, specify explicitly from which table to take fields

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question