tabl

white10 · 07-04-2007, 08:09 AM

Hi Guys

I want to display data from my agents table againts data from a client table , but each day new clients are added, and only those clients from that day must be displayed to the agents.

Can anyone help me..

white10 · 07-05-2007, 04:51 AM

Hi Guys
I figured it out I created a another table called agent_client which contains the ids for both the agents and clients and linked the 2 tables to the agent_client table

chicgeek · 07-05-2007, 07:23 AM

Thanks for sharing your result!

Utropicmedia-karl · 07-05-2007, 12:03 PM

Quote:

Originally Posted by white10

Hi Guys
I figured it out I created a another table called agent_client which contains the ids for both the agents and clients and linked the 2 tables to the agent_client table

you could have also done a join against the two original tables you had then used the WHERE to filter on date.