tbl_joblistings and tbl_languages has a 1 to many relationship with tbl_job_languages and table tbl_joblistings and tbl_industries has a 1 to many relationship with tbl_job_industries. Both tbl_job_languages and tbl_job_industries is made up of a compound primary key.
what is the sql syntax to join these tables if I want to search a job by language_Name and industry_Name. E.g. select everything from tbl_joblistings where language_name is French and industry sector is IT?