Not unique table/alias: 'fd_collection'

[mugwumpr]

I'm trying to join two tables (fd_eggs and fd_collection) so that I can use info from both, but I keep getting the error

Not unique table/alias: 'fd_collection'

I've hunted around, but can't find anything that gives me a hint as to where the error is.

Here's the query:

PHP Code:

$query = "SELECT fd_eggs.ID AS feid, fd_eggs.name AS fename, fd_collection.member_ID as memb
 FROM fd_eggs, fd_collection
 LEFT JOIN fd_collection
 ON fd_eggs.ID = fd_collection.egg_ID
 ORDER BY releasedate DESC"; 


Any advice greatly appreciated.

(gawd, i hate being this much of a n000b)

[sde]

can you clarify your table names, and field names of those 2 tables? just the relevant fields will be fine.

[mugwumpr]

fd_eggs:
ID (primary)
name (unique)
releasedate

fd_collection:
egg_ID (fk to fd_eggs.ID)
member_ID (fd to fd_members.ID)
egg_name

fd_eggs holds all the info about the eggs (natch), and fd_collection is like an intermediary table that connects fd_eggs to the fd_members that own them.

Does that help?

[sde]

change this

FROM fd_eggs, fd_collection

to this

FROM fd_eggs

also, you may want to get into the habbit of using INNER JOIN instead of left join for performance reasons. only use left join when you absolutely have to.

[mugwumpr]

Thank you again! It's working now.

I used LEFT JOIN here because, according to what I've read at least, it's the only thing that will pull all the info from fd_eggs even if there's no corresponding info in fd_collections. Will INNER JOIN do that too, or does it only pull rows where there's matching data?

[sde]

left join is correct then. inner join will not include any records that don't share the join values.