HELP! Create Table using SQL/Access/ ASP (Classic)
Posted on 2006-03-26
Suppose I am selling tickets to an event.
The ticket includes BUS transporation to the event
Each bus has 56 seats
when one bus is full I need to create a new table for another bus
so..how do I "name" the table such that each name is unique?
For example (and point out SQL ERRORS please, im a newbie)
create table bus '<--------------- this must be in some sorta sequence to create different names
bus_cost number(20), '<----------- Question: should'nt this be a floating point number?
I hope I have made my question clear.