I have two tables like TaxiBookingDetails which has LoginId,BookingDate,TaxiType (4seater or 8 seater) etc and BookingID I make it as primary key.
I have another table called TaxiCountDetails which has TaxiNo and Taxitype .
My problem is I want to select or assign to the BookingID for TaxiNo.
For example I booked 1 taxi. So when I click the button in front end, it use to display the
bookingID,Taxitype and TaxiNo.
Front end I am using asp.net 2005.
For that how to write a query in SQL Server to select all the columns. Pls tell me now.