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