#
# Table structure for table 'firms'
#

CREATE TABLE  /*!32300 IF NOT EXISTS*/  firms (
  IDFirm int( 3 )  autoincrement,
  FirmName varchar( 250 ) 
);



#
# Table structure for table 'groupworks'
#

CREATE TABLE  /*!32300 IF NOT EXISTS*/  groupworks (
  IDGroupWorks int( 3 )  autoincrement,
  IDFirm int( 10 ) unsigned ,
  GroupWorksName varchar( 250 ) 
);


#
# Table structure for table 'works'
#

CREATE TABLE  /*!32300 IF NOT EXISTS*/  works (
  IDWorks int( 3 ) autoincrement ,
  WorkName varchar( 250 ) ,
  IDGroupWorks int( 10 ) unsigned 
);

select * from works, groupworks, firms where
works.IDGroupWorks=groupworks.IDGroupWorks and 
firms.IDFirm=groupworks.IDFirm and
((WorkName like '%продажа%') or 
(GroupWorksName like '%продажа%') or 
(FirmName like '%продажа%' ))