sql producing duplicate column id on join? Is there any way to only show one id column which is used to join on other tables?
This query produces two id columns used to join each other as primary and foreign key. I only want it to repeat the id column once.
SELECT * 
FROM products 
JOIN productimg ON products.id = productimg.id 
WHERE products.id IN (1, 2, 3)

Query results:
id    name     cid  stk prc    id       url
 1  product1    1   10  3000    1   /static/images/dresses/td1.jpg
 2  product2    2   10  2500    2   /static/images/dresses/td2.jpg
 3  product3    2   4   4000    3   /static/images/dresses/td3.jpg
SELECT products.*, productimg.url
  FROM products JOIN productimg
  ON products.id = productimg.id
  WHERE products.id IN (1, 2, 3)