skaterdav85 Posted September 11, 2010 Share Posted September 11, 2010 I have 2 tables:owners (id, name)pets (id, name, owner_id)I wanted to try using a full join to bring all the results back from both tables whether there is a match or not. Here is my query: SELECT owners.name, pets.nameFROM ownersFULL JOIN petsON owners.id = pets.owner_id It does not work however. I get an error saying: #1054 - Unknown column 'owners.name' in 'field list'Am I using the full join incorrectly? Link to comment Share on other sites More sharing options...
thescientist Posted September 12, 2010 Share Posted September 12, 2010 it looks right. are you sure the field names are right in the DB? Link to comment Share on other sites More sharing options...
skaterdav85 Posted September 12, 2010 Author Share Posted September 12, 2010 yes the field names are correct. I am just testing the sql query in phpmyadmin. Any other ideas as to why it is not working properly? mysql supports full joins right? Link to comment Share on other sites More sharing options...
justsomeguy Posted September 13, 2010 Share Posted September 13, 2010 http://www.xaprb.com/blog/2006/05/26/how-t...-join-in-mysql/ Link to comment Share on other sites More sharing options...
skaterdav85 Posted September 13, 2010 Author Share Posted September 13, 2010 ohhh so mysql doesnt support full joins? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.