urquel thanks for the reply. What you pointed out does make alot of sense however i still have no luck with it, this is what I did.

INSERT INTO `demo` ( `MPI` , `ID1` , `ID2` , `date entered` , `first name` , `MI` , `last name` , `occupation` , `home phone` , `work phone` , `ssn` , `address` , `city` , `state` , `zip` , `complaint` , `medication` , `pcphysician` , `staffphys` , `refphysician` , `age` , `dob` , `sex` , `marital status` , `race` , `information given by` , `admitted by` , `admitting diagnosis` , `date modified` , `height` , `weight` , `bmi` , `psgnum` , `latestpsgdate` , `msltnum` , `latestmsltdate` )
SELECT ( `MPI` , `ID1` , `ID2` , `date entered` , `first name` , `MI` , `last name` , `occupation` , `home phone` , `work phone` , `ssn` , `address` , `city` , `state` , `zip` , `complaint` , `medication` , `pcphysician` , `staffphys` , `refphysician` , `age` , `dob` , `sex` , `marital status` , `race` , `information given by` , `admitted by` , `admitting diagnosis` , `date modified` , `height` , `weight` , `bmi` , `psgnum` , `latestpsgdate` , `msltnum` , `latestmsltdate` )
FROM demographics
LEFT JOIN demo ON demographics.MPI = demo.MPI
WHERE demo.MPI IS NULL

#1052 - Column 'MPI' in field list is ambiguous

Then I thought my first step should try to create the same result as using *. I can't even do that I replaced * with ( `MPI` , `ID1` , `ID2` , `date entered` , `first name` , `MI` , `last name` , `occupation` , `home phone` , `work phone` , `ssn` , `address` , `city` , `state` , `zip` , `complaint` , `medication` , `pcphysician` , `staffphys` , `refphysician` , `age` , `dob` , `sex` , `marital status` , `race` , `information given by` , `admitted by` , `admitting diagnosis` , `date modified` , `height` , `weight` , `bmi` , `psgnum` , `latestpsgdate` , `msltnum` , `latestmsltdate` ) no luck error #1052 - Column 'MPI' in field list is ambiguous. and those are all the fields.

Thanks You

Joe