JTapp Posted February 17, 2008 Share Posted February 17, 2008 OK - I will spend HOURS on anything I get from you guys. Thanks in advance for reading my immature code. The following is my crap code. Two tables: Table 1 is tblLodges and its field is strLodgeName - Unique field is lngLodgeID Table 2 is tblOfficers and the fields are strLastName and strFirstName - Unique field is also lngLodgeID I need my statement to work from to a drop down html search page. $query = "SELECT tblLodges.strLodgeName, tblOfficers.strLastName, tblOfficers.strFirstName". "FROM tblLodges, tblOfficers ". "WHERE tblLodges.lngLodgeID = tblOfficers.lngLodgeID"; Quote Link to comment Share on other sites More sharing options...
JTapp Posted February 17, 2008 Author Share Posted February 17, 2008 This was resolved in another post. Just trying to close it by typing this post. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.