Hello all, I have two tables that look like this:
Routes table Schedule_ID School_ID Route_ID Main_St_ID X_Street_ID Side Pick_Up Drop_Off Streets table Street_ID Street_Name The Main and X street ID's in the Routes table are joined to the Street_ID field in Streets What I am trying to do is create a query so that I have select options that look like this: Baldy Mesa Rd @ Solano Rd Baldy Mesa Rd @ Goss Rd And so on. But when I create my query, I get no records returned if I join the Street_Id to the Main and X Street ID's in the Routes table. Do I need to do a sub query, or a query of queries in CF to make this work? I have tried usining AND, OR, Full Outer Join, Right Outer Join, Join and so on to no avail. Thanks, Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2948 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
