Oprette view

Det er helt sikkert et join problem. Ville være nemmere at hjælpe, hvis du viste os koden til view'et :o)

lyder som en manglende join betingelse

select `greenbox`.`_user`.`id` AS `id`,`greenbox`.`_user`.`_name` AS `_name`,`greenbox`.`_user`.`_password` AS `_password`,`greenbox`.`_user`.`_language` AS `_language`,`greenbox`.`_user`.`_address_id` AS `_address_id`,`greenbox`.`_user`.`_company_id` AS `_company_id`,`greenbox`.`_user`.`_department_id` AS `_department_id`,`greenbox`.`_user`.`updated` AS `updated`,`greenbox`.`_user`.`_extension_id` AS `_extension_id`,`greenbox`.`_user`.`_cellphone_id` AS `_cellphone_id`,`greenbox`.`_user`.`_resource` AS `_resource`,`greenbox`.`_user`.`_keycard_id` AS `_keycard_id`,`greenbox`.`_user`.`_secretary_user_id` AS `_secretary_user_id`,`greenbox`.`_user`.`_boss_user_id` AS `_boss_user_id`,`greenbox`.`_user`.`_alternate_user_id` AS `_alternate_user_id`,`greenbox`.`_user`.`_title` AS `_title`,`greenbox`.`_user`.`_hidden` AS `_hidden`,`greenbox`.`_user`.`_forename` AS `_forename`,`greenbox`.`_user`.`_surname` AS `_surname`,`greenbox`.`_user`.`_initials` AS `_initials`,`greenbox`.`_user`.`_emailaddress` AS `_emailaddress`,`greenbox`.`_user`.`_office` AS `_office`,`greenbox`.`_user`.`_area` AS `_area`,`greenbox`.`_user`.`_fax_id` AS `_fax_id`,`greenbox`.`_user`.`_ddinumber` AS `_ddinumber`,`greenbox`.`_user`.`_voicemail_extension_id` AS `_voicemail_extension_id`,`greenbox`.`_user`.`_status` AS `_status`,`greenbox`.`_user`.`_access` AS `_access`,`greenbox`.`_user`.`_flag` AS `_flag`,`greenbox`.`_user`.`_user01` AS `_user01`,`greenbox`.`_user`.`_user02` AS `_user02`,`greenbox`.`_user`.`_user03` AS `_user03`,`greenbox`.`_user`.`_user04` AS `_user04`,`greenbox`.`_user`.`_user05` AS `_user05`,`greenbox`.`_user`.`_user06` AS `_user06`,`greenbox`.`_user`.`_user07` AS `_user07`,`greenbox`.`_user`.`_user08` AS `_user08`,`greenbox`.`_user`.`_user09` AS `_user09`,`greenbox`.`_user`.`_user10` AS `_user10`,`greenbox`.`_user`.`_user11` AS `_user11`,`greenbox`.`_user`.`_user12` AS `_user12`,`greenbox`.`_user`.`_user13` AS `_user13`,`greenbox`.`_user`.`_user14` AS `_user14`,`greenbox`.`_user`.`_user15` AS `_user15`,`greenbox`.`_user`.`_user16` AS `_user16`,`greenbox`.`_user`.`_user17` AS `_user17`,`greenbox`.`_user`.`_user18` AS `_user18`,`greenbox`.`_user`.`_user19` AS `_user19`,`greenbox`.`_user`.`_user20` AS `_user20`,`greenbox`.`_user`.`_yesno01` AS `_yesno01`,`greenbox`.`_user`.`_yesno02` AS `_yesno02`,`greenbox`.`_user`.`_yesno03` AS `_yesno03`,`greenbox`.`_user`.`_yesno04` AS `_yesno04`,`greenbox`.`_user`.`_yesno05` AS `_yesno05`,`greenbox`.`_user`.`_yesno06` AS `_yesno06`,`greenbox`.`_user`.`_yesno07` AS `_yesno07`,`greenbox`.`_user`.`_yesno08` AS `_yesno08`,`greenbox`.`_user`.`_yesno09` AS `_yesno09`,`greenbox`.`_user`.`_yesno10` AS `_yesno10`,`greenbox`.`_user`.`uid` AS `uid`,`greenbox`.`_extension`.`_number` AS `_number`,`greenbox`.`_extension`.`_pbx_id` AS `_pbx_id`,`greenbox`.`_extension`.`_description` AS `_description`,`greenbox`.`_extension`.`_status_id` AS `_status_id`,`greenbox`.`_extension`.`_extensiontenant` AS `_extensiontenant`,`greenbox`.`_extension`.`_monitor` AS `_monitor`,`greenbox`.`_extension`.`_flmestate` AS `_flmestate`,`greenbox`.`_extension`.`_dndstate` AS `_dndstate`,`greenbox`.`_extension`.`_lines` AS `_lines`,`greenbox`.`_extension`.`_monitorgroup` AS `_monitorgroup`,`greenbox`.`_extension`.`_extensiontype` AS `_extensiontype` from (`greenbox`.`_user` join `greenbox`.`_extension`)

... from (`greenbox`.`_user` join `greenbox`.`_extension` on _user.xxx = _extension.yyy)

du skal selv vide hvilke felter som kobler de 2 tabeller sammen (xxx og yyy)

jepper - dem har jeg tilføjet og nu virker det :-)

arne - smid et svar

svar