Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link
i want query for inserting two input parameters and remaining fields from other table in single query.
INSERT INTO Members ( memberName, userID)
VALUES('MYNAME', (SELECT userID FROM USERS WHERE userUNIQUEID = '123'));
i need to insert a row into member table.
i want to pass 'MYNAME' as parameter and UserId will be from select statement.
can any one please give me correct syntax of the query.