why do i need to do an inner join? here's my actual query .. joining 6 tables =)
this will be a thread stretcher .. sorry =/
Code:
SELECT details.detail_id,issues.issue_id,details.open,contacts.f_name,contacts.l_name,issues.topic,agents.nick,products.product_name
FROM issues,details,contacts,agents,products,issue_product
WHERE issues.issue_id=details.issue_id AND issues.contact_id=contacts.contact_id AND details.agent_id=agents.agent_id AND issue_product.product_id=products.product_id AND issue_product.issue_id=details.issue_id ORDER BY details.detail_id DESC LIMIT 10