ccirn.org

Home > Not Unique > Error Number 1066 Not Unique Table/alias Codeigniter

Error Number 1066 Not Unique Table/alias Codeigniter

Contents

Rotations of a number How much clearer are stars in earths orbit? Thanks. –AgentConundrum Aug 21 '11 at 0:52 | show 6 more comments up vote 1 down vote You are taking the Cartesian product of the users table with itself when you Join them; it only takes a minute: Sign up #1066 - Not unique table/alias: up vote 0 down vote favorite Can you please help me out. Join them; it only takes a minute: Sign up Not unique table/alias codeigniter up vote 0 down vote favorite I get the error ERROR 1066 (42000): Not unique table/alias: 'order_has_artikelgroup' I have a peek at this web-site

Placed on work schedule despite approved time-off request. Read my post over and refer to how you load models from codeigniters website if you really need to.. How to write name with the letters in name? How to deal with players rejecting the question premise Last Digit of Multiplications Why can Solve solve this system of expressions but not a similar system? http://stackoverflow.com/questions/33060002/error-number-1066-not-unique-table-alias-service-in-codeigniter

1066 Not Unique Table Alias Mysql Error

Given a string, Return its Cumulative Delta Program to count vowels How is the Heartbleed exploit even possible? function get_user_info($id) { $this->db->select('*'); $this->db->from('users'); $this->db->where('users.id', $id); $query = $this->db->get(); if ($query->num_rows() == 1) { return $data = $query->row(); } else { return NULL; } } And this is from my I don't think you mean to be taking the Cartesian product at all. How to deal with players rejecting the question premise Logical fallacy: X is bad, Y is worse, thus X is not bad Did Hillary Clinton say this quote about Donald Trump

Got the offer letter, but name spelled incorrectly Effects of atmospheric gases on colour of aurora Square, diamond, square, diamond How much Farsi do I need to travel within Iran? How would you help a snapping turtle cross the road? asked 2 years ago viewed 127 times active 2 years ago Related 42CodeIgniter Active Record - Get number of returned rows140Which version of CodeIgniter am I currently using?0Codeigniter active Record44subquery in Try: SELECT * FROM users JOIN user_profiles ON users.id = user_profiles.user_id share|improve this answer answered Aug 20 '11 at 23:40 Paulpro 83.8k11148179 Right but I'm trying to figure out

In this instance, just use: $this->db->select('*'); $this->db->from('service'); $this->db->join('user', 'user.user_email = service.user_email', 'inner'); $query = $this->db->get(); Since the $this->db->join('service', 'service.user_email = user.user_email', 'inner'); is redundant here (you've already joined these tables on Error 1066 42000 Not Unique Table Alias Linear Mode Threaded Mode View a Printable Version Subscribe to this thread Add Poll to this thread Send thread to a friend Dev Shed Forums Navigation Forums Tools Newsletter Signup Articles why does my voltage regulator produce 5.11 volts instead of 5? Can we use mathematical induction when induction basis is 'too' broad?

Bash command to copy before cursor and paste after? Try removing the $this->db->from('users'); line and seeing if that resolves the issue. Faq Reply With Quote Share This Thread  Tweet This + 1 this Post To Linkedin Subscribe to this Thread  Subscribe to This Thread « Previous Thread | Next Thread Error Number: 1066 Not unique table/alias: 'core_user' SELECT * FROM (core_user, core_user) JOIN core_company ON core_company.cmp_id = core_user.cmp_id WHERE usr_email = '[email protected]' AND usr_password = '123456' AND cmp_name = 'corpoleave' Filename:

Error 1066 42000 Not Unique Table Alias

Meaning of "it's still a land" more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology news The mortgage company is trying to force us to make repairs after an insurance claim Are professors allowed to participate in political activities? 1066 Not Unique Table Alias Mysql Error Empirical CDF vs CDF How to deal with players rejecting the question premise Windows or Linux for Monero What's the most recent specific historical element that is common between Star Trek Error Code 1066 Not Unique Table Alias core_user core_company ct_company i want to join 2 tables core_user and core_company where foriegn key is cmp_id column..

Not the answer you're looking for? Check This Out It's fine :) –Walter Deda Jul 23 '14 at 12:09 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote You have selected table "albuns" two times: How to describe sand flowing through an hourglass Empirical CDF vs CDF What emergency gear and tools should I keep in my vehicle? Remember me Home Forums Search Members Help CodeIgniter.com Twitter CodeIgniter Forums CodeIgniter Archived (from EllisLab) Archived Development & Programming Error Number: 1066 - Not unique table/alias Thread Closed Codeigniter Join

Isn't that more expensive than an elevated system? How can a nocturnal race develop agriculture? What's a word for helpful knowledge you should have, but don't? http://ccirn.org/not-unique/error-number-1066-not-unique-table-alias.php Browse other questions tagged codeigniter or ask your own question.

How to avoid Root[] when using Solve[] Logical fallacy: X is bad, Y is worse, thus X is not bad What Is The "Real Estate Loophole"? Join them; it only takes a minute: Sign up Error Number: 1066 Not unique table/alias: 'service' in codeigniter up vote 0 down vote favorite Want to get all services in one Browse other questions tagged codeigniter or ask your own question.

For..

Not Unique Alias-21066 - Not unique table/alias:1How do I query these three specific tables for information with inner joins? Sincerly Jonas php mysql codeigniter join pyrocms share|improve this question edited Feb 6 '12 at 10:44 asked Feb 6 '12 at 10:00 Jonas m 1,6201028 Updated with solution –Jonas Got the offer letter, but name spelled incorrectly Chess puzzle in which guarded pieces may not move What's the most recent specific historical element that is common between Star Trek and How often do professors regret accepting particular graduate students (i.e., "bad hires")?

Rotations of a number A word like "inappropriate", with a less extreme connotation How to tell why macOS thinks that a certificate is revoked? Why is absolute zero unattainable? Not unique table/alias: 'File'0A Database Error Occurred Error Number: 1066 Not unique table/alias: Hot Network Questions Do Art and Art come back after dying in Fallout 4? have a peek here Effects of atmospheric gases on colour of aurora A word like "inappropriate", with a less extreme connotation What is the most expensive item I could buy with £50?

Devshed Newbie (0 - 499 posts)     Join Date Aug 2004 Location Brisbane, Australia Posts 157 Rep Power 14 Error #1066 - Not unique table/alias: 'TableName' Hi, I With the passing of Thai King Bhumibol, are there any customs/etiquette as a traveler I should be aware of? A Database Error Occurred Error Number: 1066 Not unique table/alias: 'users' SELECT * FROM (`users`, `users`) JOIN `user_profiles` ON `users`.`id` = `user_profiles`.`user_id` Filename: /home/xtremer/public_html/kowmanager/models/cpanel/dashboard.php Line Number: 38