Sql Query for Table based on start and end character

Question

Book ID	Name	Autor
1	ABC	Manoj
2	BBC	mnoj

Self id	Start character	end car
1	A	C
2	D	I

 

I have two table Now I want record from first table with Selfid ( second table contains Starting character and End character like in above table all book Started with A,B,C comes with self id 1)