Red Gate forums :: View topic - Multi_part Identifier
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

Multi_part Identifier

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
gijoe0813



Joined: 24 Jul 2014
Posts: 1
Location: Kern county Ca

PostPosted: Thu Jul 24, 2014 11:35 pm    Post subject: Multi_part Identifier Reply with quote

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
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 249
Location: Red Gate Software

PostPosted: Fri Jul 25, 2014 9:47 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group