Search Join (Unknown column 't0.child_id' in 'on clause') 103 Postsshubhaanshu 4 years ago2TopicSearch Join field is showing error "1054 Unknown column 't0.child_id' in 'on clause'trying to use this field with custom content types:project, children, weightI have 3 tables :1. Project (id, project_name)2. Children (id, project_id, name, age)3. Weight (id, child_id, weight)I am trying to create a "list and search" based on "Weight" content type in which:Created a Filter by "project" (select simple with storage Project --> id)to achieve this I created a search join field "weight_join" in "Weight" Search type (screenshot 1)Please give me any clue to resolve it...Best Regards 4229 PostsKadministrator 4 years ago1Level 1 As written in field description "The table on the right side of each Join line (parameter), is assumed to be already known/defined by the query."Please copy the whole query you are getting (with debug mode on) before and after you add join field so we can see why it is not working 103 Postsshubhaanshu 4 years ago0Level 2Thanks for your guidance Klas!Now I started with id #__content as the Join(1) at the right input boxesthen my other fields....And it is working perfectly...Thanks for your kind support and sorry for my silly questions/problems.