Hi all,

$selcount = "SELECT * FROM autoalto_mail as a1, autoalto_contractor_sentitems as a2 where a1.flag=a2.flag='1' " ;

Recommended Answers

All 3 Replies

this is correct one:

SELECT * FROM autoalto_mail as a1, autoalto_contractor_sentitems as a2 where a1.flag='1' and a2.flag='1'";

Hi Shanthi

This is working fine...............

Fine...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.