Hi GUYS,
having a spot of trouble. This is my code
select TicketType, Price
from ticket a(nolock)
inner join event b on a.EventID = b.EventID;
I get the error code 1064 inner join event b on a.EventID = b.EventID' at line
I am trying to write a statment that willput a transaction lock on the booking to prevent another visitor making a booking whilest the payment is processing.
my database design can be found here
http://homepage.ntlworld.com/unixhome/latest.htm
