Haulin Azz 3D Drag Racing
References
Category:American auto racing teams
Category:Drag racing
Category:Drag racing videos
Category:Sports teams in Chicago
Category:Motor racing teams based in the United States
Category:American racing driversQ:
Add new column to query if two columns are matched
I have the following query:
SELECT a.category, a.name, b.name, b.category
FROM products a
JOIN categories b ON a.category = b.category
It gives me the following result:
category       name         name         category
shirts          black shirt  blue shirt   men
shirts          black shirt  red shirt    men
shoes           black shoe  red shoe     men
shoes           red shoe    blue shoe    women
shoes           blue shoe   black shoe   women
How do I add a new column to this query such that when I write SELECT * I get the following result:
category       name         name         category    name_category
shirts          black shirt  blue shirt   men         men
shirts          black shirt  red shirt    men         men
shoes           black shoe  red shoe     men         men
shoes           red shoe    blue shoe    women       women
shoes           blue shoe   black shoe   women       women
Thank you!
A:
SELECT a.category, a.name, b.name, b.category,
       b.name_category
FROM products a
JOIN categories b ON a.category = b.category
be359ba680

Haulin Azz 3D Drag Racing urazeba