tabl

[white10]

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]

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]

Thanks for sharing your result!

[Utropicmedia-karl]

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.