drifter Posted December 20, 2006 Share Posted December 20, 2006 I am trying to create a table from a query, but the query I have has a left join on user_id - so when there is not match, user_id shows up inthe table twice - once as the ID, once as NULL - this gives me duplicate rows, and the create table fails. What can I do about this?ThanksScott Quote Link to comment Share on other sites More sharing options...
drifter Posted December 20, 2006 Author Share Posted December 20, 2006 found out I can get around it by not using the * Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.