Multi_part Identifier

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Multi_part Identifier

Postby gijoe0813 » Thu Jul 24, 2014 11:35 pm

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
gijoe0813
 
Posts: 1
Joined: Thu Jul 24, 2014 6:34 pm
Location: Kern county Ca

Postby Aaron Law » Fri Jul 25, 2014 9:47 am

Hi gijoe0813,

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.
Aaron Law
 
Posts: 252
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests