I am newbie at zend and relationships in databases and would like some advice if I am doing this correctly.
I would be very grateful if somebody could point me in right direction.
In my setup I have 2 tables:
Table #1
name: products
columns: idproducts, type, quantity, field1, field2, field3
example entry for table products:
1 | foo | 10 | 1 | 3 | 2
Table #2
name: fields
columns: idfields, name
example entries for table fields:
1 | text1
2 | text2
3 | text3
I need a query that would join two tables and return something like that:
1 | foo | 10 | text1 | text3 | text2
Is this possible?
Thanks
