Member Avatar for jacob21

Hi,
SELECT * FROM admin INNER join category on category.cat_id=admin.cat_id where cat_id=5;

showing an error.
#1052 - Column 'cat_id' in where clause is ambiguous

need suggestions..

  • 2 Contributors
  • 1 Reply
  • 31 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by cwarn23
Member Avatar for cwarn23

You need the table name conjoined to the column name. For example:

SELECT * FROM admin INNER join category on category.cat_id=admin.cat_id where category.cat_id=5
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.