MySQL Subquery

Need some help writing the following subquery in MySQL: Select all fields in Table3 and one row from (Table1 joined to Table2 where [login to view URL] is between [login to view URL] and [login to view URL]) In other words, Table3 has 12 columns. One of those Columns has one value (a number) that lays between two values in one row in Table1 which is joined to Table2. Example Table1 Field1,Field2,Field3 1576500,1576529,Blue 1576530,1576545,White 67800,67900,Red 100,200,Green 56800,56900,Violet Example Table2 Violet,UY,9S Green,8U,PK Purple,PO,3D Magenta,ME,Q8 Red,EE,KI Blue,NN,H7 White,YY,Y7 Black,AA,A3 Yellow,BB,B1 Example Table3 Field1,Field2,Field3,Field4,Field5,Field6,Field7,Field8,Field9,Field10,Field11,Field12 Apple,Banana,Strawberry,Prunes,1576532,GreenApple,RedApple,Pineapple,RedGrape,GreenGrape,Melon,HoneyDew Kiwi,Lime,Orange,Lettuce,67890,Carrots,Radish,Mushroom,Spinach,Sage,Basil,Dill Example Results Table3(Field5,Field6,Field7,Field8,Field9,Field10,Field11,Field12),Table1.(Field1,Field2),Table2.(Field2,Field3) 1576532,GreenApple,RedApple,Pineapple,RedGrape,GreenGrape,Melon,HoneyDew,1576530,1576545,YY,Y7 67890,Carrots,Radish,Mushroom,Spinach,Sage,Basil,Dill,67800,67900,EE,KI