Welcome Guest, Not a member yet? Register   Sign In
[solved] Inner Join Active Record
#3

[eluser]a&w[/eluser]
Thanks for your help, yields same result:

Previous query:
Code:
FROM (`table_1`, `table_2`)
INNER JOIN `table_2` ON `table_2`.`id` = `table_1`.`id`
ORDER BY `table_1`.`id` ASC
LIMIT 25;


With your code (same thing pretty much...same result nonetheless):
Code:
<h1>A Database Error Occurred</h1>
<p>Error Number: 1066</p><p>Not unique table/alias: table_2</p>

<p>
SELECT *
FROM (`table_2`, `table_1`)
INNER JOIN `table_2` ON `table_1`.`id` = `table_2`.`id`
ORDER BY `table_1`.`id` asc
LIMIT 25
</p>


Messages In This Thread
[solved] Inner Join Active Record - by El Forum - 12-22-2008, 05:48 PM
[solved] Inner Join Active Record - by El Forum - 12-22-2008, 06:49 PM
[solved] Inner Join Active Record - by El Forum - 12-22-2008, 07:09 PM
[solved] Inner Join Active Record - by El Forum - 12-22-2008, 07:24 PM
[solved] Inner Join Active Record - by El Forum - 12-22-2008, 07:49 PM



Theme © iAndrew 2016 - Forum software by © MyBB