Here's my table specs
Code:
`clients` (
  `id` tinyint(11) NOT NULL auto_increment,
  `name` varchar(70) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `title` varchar(50) NOT NULL default '',
  `phone` varchar(20) NOT NULL default '',
  `company` tinyint(11) NOT NULL default '0',
  `owner` tinyint(11) NOT NULL default '0',
  `private` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM
1st query: "SELECT * FROM clients WHERE private='no'";
2nd query: "SELECT * FROM clients WHERE private='yes' and owner='$owner'";

Is there a way i can join those statement on the condition of 'company'. Because i would like to get all clients from 1st and 2nd query where the company field ='$company';



Any suggestions?