I entered the following query:
select tbl_skill.s_name
from tbl_skill, tbl_percentmap
where tbl_percentmap.people_id = 5;
Describe tbl_skill:
s_id (primary key)
s_name
s_level
prereq_id
Describe tbl_percentmap:
pm_id (primary key)
people_id (int, foreign key)
skill_id (int foreign key)
percentage (tinyint)
When I hit enter on this query, it spammed to heck and back, printing out what as near as I could tell was anything it felt like printing from the entire table, not just from rows where people_id = 5.
Anyone have any idea why this is happening?
select tbl_skill.s_name
from tbl_skill, tbl_percentmap
where tbl_percentmap.people_id = 5;
Describe tbl_skill:
s_id (primary key)
s_name
s_level
prereq_id
Describe tbl_percentmap:
pm_id (primary key)
people_id (int, foreign key)
skill_id (int foreign key)
percentage (tinyint)
When I hit enter on this query, it spammed to heck and back, printing out what as near as I could tell was anything it felt like printing from the entire table, not just from rows where people_id = 5.
Anyone have any idea why this is happening?