Re: Select problem - Is this possible?

[Michael Pryfogle]

This gives me something similar to OR-ing the two statements together. I need something that would join the two tables on say c.id. So if type=23 was a starttime and type=24 was an endtime refering to call to a customer and there is1 starttime and 1 endtime, OR-ing would give me 2 where what I would want is 1 because each call to the c.id has a starttime and and end time.

table e
------------------------------
id | c_id | type | description
------------------------------
1 1 23 12:35:46
2 1 24 12:46:32

table c
---------------------
id | name | email
---------------------
1 Bob [e-mail]



Edited 3 time(s). Last edit at 06/28/2005 08:02AM by Michael Pryfogle.