Forum Moderators: open

Message Too Old, No Replies

Query From 3 Tables

Join 3 Tables With Condition

         

Tornado2000

3:31 pm on May 11, 2009 (gmt 0)

10+ Year Member



advertisers is a table with two columns unique id and name
views is a table with two columns id and advtid
msgs is a table with two columns id and advtid

How do I fetch only those advertisers who have atleast one msg or one view and order by total msgs + total views?

Any solution?