want to combine these two operations into one query - looked around but got info overload. hoping for someone to just put me on the right path please.
can save myself an ugly mess if I can combine the following:
INSERT into member_table (new member's name, login, password, etc). table makes a new member_id# auto-inc for this guy.
now, within the same query, I want to duplicate that same member_id# into column couple_id#. both columns are within the same record.