troubleshooting Question

"select into" from joined tables

Avatar of yossikally
yossikally asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
2 Comments1 Solution400 ViewsLast Modified:
This must be a very simple question if you have any real experience (obviously I don't)
I have:
  t_player table
  tk_playerTeam table

I want to select records from t_player into t_temp, but only if they do not belong to any team.
So I came up with the following:

select * into t_temp from t_player p
left join tk_playerTeam pt on pt.playerID = p.playerID
where pt.teamID is null

on which I get:
"Column names in each table must be unique...."
I don't want to specify each field from t_player.  All t_player fields must be replicated to t_temp
Database Consultant
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros