Hi Simon,
would it not be
INSERT INTO Users
INNER JOIN Wages
ON Users.User_ID = Wages.User_ID
(Users.Surname, Wages.NINumber)
VALUES ('Bloggs', 'NY012398B')
eh?
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]