Thanks Tom, i have been through that, but, unfortunately to no avail. Until.....
I found out the complete folder structure was messed up in the components directory, for some reason that i have yet to discover. Updated that, cleaned up and poof. It worked as expected. So, my schema was correct and the JOIN is now working fine.
Thanks for bearing with me, all!
@ Bruno or anyone that knows: what would the syntax be in the WHERE clause when i need to select based on the JOINS? (selecting on field names in the joined tables)
I need to JOIN so, that based on the Serivce selected there is a connection with Subservices based on service_id wich has a connection on its own with SubServicesoptions based on subservice_id.
[ed. note: thapriest86 last edited this post 13 years ago.]
