OT: SQL Query

[Paul Giesenhagen]

I have three tables and I know the guideID.  The Fusion table below brings the guides and the lakes together.  If a Guide is a guide at 1 or more lakes, the lakeID and the guideID are put into a row into the fusion table.  Guides can be associated with many lakes and many lakes associated with a guide.

I want to display a series of checkboxes for the list of ALL lakes .. and then denote (check) the checkboxes of the lakes that the KNOWN guideID is a part of.  

So If I am viewing guideID = 1001 then I want to see all the lakes, but distinguish which lakes are associated with guideID = 1001

Can this be done in a single query or am I going to need some CF integration.?

Lakes Table:
====================
lakeID, lakeName

Guide Table
====================
guideID, companyName

Fusion Table
====================
fusionID, lakeID, guideID

Thanks
Paul Giesenhagen
QuillDesign

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---