Codezwiz >> Forums >> The Board >> SQL help

ok, here goes....

Table employee has columns id, name
Table ticket has columns id, emp_id, cust_id, office, issue_date
Table customer has columns id, name

here is what I'm trying to do:
SELECT *
FROM ticket.a, employee.b, customer.c
WHERE a.office = 'Dallas'
AND a.cust_id = 75
AND a.emp_id = b.id
AND a.cust_id = c.id
AND a.emp_id = 144 OR a.emp_id = 18
ORDER BY a.tech_id, a.cust_id, a.issue_date

yea, I think that should do what I need......

its returning like 136,000+ records....and I'm pretty sure thats not right.....theres only ll records in ticket, 74 records in customers, and 205 in employee.....

TIA,
Mike

Instead of ticket.a, employee.b and customer.c, try ticket AS a, employee AS b, customer AS c.

You are also trying to order by a.tech_id, but you don't have a field listed as tech_id in the ticket table.

That may not solve the whole problem, but it should get you a little closer, I hope.

It has nothing to do with the ordering its because you have

select * from ....
you get for every table and every row in that table and their combinations a result row
you have to do
select ticket.* from ...
or another table prefix to limit the result count.

yes, thank you very much.....

mike