sql statement problem

Results 1 to 2 of 2

Thread: sql statement problem

  1. #1
    Join Date
    Dec 1969

    Default sql statement problem

    hi guys...<BR><BR>i need a hand with the correct syntax for a sql statement....<BR><BR>i have a table called &#039;bookings&#039; which has an automatically generated number in a column called bookingId. When someone makes a booking and it is written to this table i need this bookingId value generated in the bookings table to also be added in another table called &#039;transaction along with three other values stored in variables.<BR><BR>i have been attempting to use an INSERT INTO statement with a subquery (SELCT MAX (BookingId) but i keep getting syntax errors and really am just guessing as i can&#039;t find any litreature on the syntax to write such a statement...<BR><BR>cheers in advance....

  2. #2
    Join Date
    Dec 1969

    Default FaQ 79


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts