This is my table structure: The error message is: #1066 - Not unique table/alias: 'user' The following is my code. SELECT article.* , section.title, category.title, user.name, user.name FROM article INNER JOIN section ON article.section_id = section.id INNER JOIN category ON article.category_id = category.id INNER JOIN user ON...
The code below looks painstakingly long... but pls if u can spot the error, tell me.. I dont see any duplicates of the alias 'usertns_group' so i wonder why im getting that error.. post LEFT JOIN category2 as postcategory2 ON( post.category2_id = postcategory2.category2_id ) LEFT JOIN category1 as category2category1 ON( postcategory2...
Hi! I'm trying to join some tables together in MySQL, but I seem to get an error saying: #1066 - Not unique table/alias: 'calendar_jobs' I really want it to select everything from the cal_events, the 2 user bits and just the destination col from the jobs table, but become "null" if there arn't any job. A right join seemed to fit the bi...
I'm trying to do a pretty complex query in MySQL; complex for me, at least. Here's an example of what I'm trying to do: SELECT * FROM friends LEFT JOIN users ON users.uid = friends.fid1 LEFT JOIN users ON users.uid = friends.fid2 WHERE (friends.fid1 = 1) AND (friends.fid2 > 1) UNION SELECT fid2 FROM friends WHERE (friends.fid2 = 1) AN...
I'm trying to use a join on three tables query I found in another post (post #5 here). When I try to use this in the SQL tab of one of my tables in myPHPAdmin, it gives me an error: #1066 - Not unique table/alias: 'm' The exact query I'm trying to use is: select r.*,m.SkuAbbr, v.VoucherNbr from arrc_RedeemActivity r, arrc_Merchant m...