How to display or query this?

[mcapon]

TABLE 1 ITEMNO, ITEMNAME, DESCRIPT, SUPLYR,
NOTE: (ITEMNO IS A FOREIGN KEY)
TABLE 2 ITEMNO, ITEMID, QTY
NOTEITEMNO AND ITEMID IS A FOREIGN FROM TABLE 1 IN ITEMNO)

SO MY SAVE / INSERT QUERY KINDA LIKE THIS

Insert Into STRUCTURE(ITEMNO, ITEMID, QTY) values(" & TxtItemNu.Text & "," & TxtFlowerID.Text & "," & CboQuantity.Text & ")

AND MY FLEXGRID DISPLAY IS LIKE THIS

Select ITEMNO, ITEMID, QTY from STRUCTURE

BUT I LIKE TO DISPLAY LIKE THIS
Select ITEMNO, ITEMNAME, QTY WHERE ORDER BY ITEMNO
(THE ITEMNAME IS COMING FROM TABLE1)