breeze351
asked on
Need to insert a record in a person file
I know the sql is wrong.
There are 2 tables (Company and Persons)
I need to add a blank record to the person table for 1 company in the "person" file.
INSERT INTO `pers`(`TID`, `PNID`, `LNAME`) VALUES ("00000619", "0000", "Unknown") where `TID` = "00000619"
TID relates back to the company table
There are 2 tables (Company and Persons)
I need to add a blank record to the person table for 1 company in the "person" file.
INSERT INTO `pers`(`TID`, `PNID`, `LNAME`) VALUES ("00000619", "0000", "Unknown") where `TID` = "00000619"
TID relates back to the company table
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER