Multi_part Identifier
gijoe0813
Posts: 2
I used the tab key to get the fiieldds of an asterisk on 2 queries from 2 different databases . In both cases the fields populated but in one query the multi-part error appeared for each of the field and the other didn't Queries are as follows
SELECT A.PK_AddressID ,
A.StreetNumber ,
A.StreetDir ,
A.StreetName ,
A.FK_StreetType ,
A.UnitID ,
A.City ,
A.FK_State ,
A.ZipCode ,
A.isValidated ,
A.Created ,
A.Modified ,
A.RowVersion ,
A.BeatAreaCode ,
A.UnitType ,
A.SupervisorDistrict ,
A.StreetNumberFraction FROM dbo.Address AS A
SELECT PT.pp ,
PT.fname ,
PT.ssn ,
PT.datepaid ,
PT.location ,
PT.division ,
PT.unit ,
PT.id ,
PT.bdate ,
PT.edate ,
PT.pp_num ,
PT.stamp FROM dbo.payroll_tbl AS PT Really simple queries just trying to understand
SELECT A.PK_AddressID ,
A.StreetNumber ,
A.StreetDir ,
A.StreetName ,
A.FK_StreetType ,
A.UnitID ,
A.City ,
A.FK_State ,
A.ZipCode ,
A.isValidated ,
A.Created ,
A.Modified ,
A.RowVersion ,
A.BeatAreaCode ,
A.UnitType ,
A.SupervisorDistrict ,
A.StreetNumberFraction FROM dbo.Address AS A
SELECT PT.pp ,
PT.fname ,
PT.ssn ,
PT.datepaid ,
PT.location ,
PT.division ,
PT.unit ,
PT.id ,
PT.bdate ,
PT.edate ,
PT.pp_num ,
PT.stamp FROM dbo.payroll_tbl AS PT Really simple queries just trying to understand
Comments
I'm not sure that I understand what's gone wrong, could you describe the multi-part error you saw in more detail? A screenshot might be easier here.
Thanks,
Aaron.