How to reference same column twice from same table and then display in datagrid
Posted on 2007-11-19
I need to display data about cities/states in a datagrid based on a single quote. I need to display in a datagrid, Origin City, Destination City, Origin State and Origin State. The first two are from the Cities table and last two from the States table. My Quotes table has all four as foreign keys - OriginCityID, OriginStateID, DestCityID and DestStateID. My problem is how do I reference twice from same coumns in same table in my query and then display in datagrid. OriginCityID and DestCityID are basically from the same table, and same with the states.