MySQL Forums
Forum List  »  Spanish

Re: Select INNER JOIN obtener solo algunos registros
Posted by: Quarter Punch
Date: January 31, 2022 06:26PM

Thank you Peter,

This is the result of my query, from the Permissions table:

you can see, there are many options that include the word read_users, read_menus, read_cities, etc.

I am getting many records, which I don't need, example: create_users, update_users, delete_users, show_users.

"id" "name" "guard_name" "created_at" "updated_at"
"1" "admin" "web" "14/10/2019 03:29:55" "31/1/2022 11:50:53"
"2" "read_users" "web" "13/10/2019 04:16:48" "13/10/2019 04:16:48"
"3" "update_users" "web" "13/10/2019 04:16:48" "13/10/2019 04:16:48"
"4" "delete_users" "web" "13/10/2019 04:16:48" "13/10/2019 04:16:48"
"5" "create_roles" "web" "13/10/2019 04:16:48" "21/10/2019 03:48:37"
"6" "read_roles" "web" "13/10/2019 04:16:48" "21/10/2019 03:48:47"
"7" "update_roles" "web" "13/10/2019 04:16:48" "21/10/2019 03:48:55"
"8" "delete_roles" "web" "13/10/2019 04:16:48" "21/10/2019 03:49:12"
"9" "create_permisos" "web" "13/10/2019 04:16:48" "21/10/2019 03:47:10"
"10" "read_permisos" "web" "13/10/2019 04:16:48" "21/10/2019 03:47:51"
"11" "update_permisos" "web" "13/10/2019 04:16:48" "21/10/2019 03:48:08"
"12" "delete_permisos" "web" "13/10/2019 04:16:48" "21/10/2019 03:48:20"
"14" "create_users" "web" "13/10/2019 04:16:48" "13/10/2019 04:16:48"
"15" "show_users" "web" "21/10/2019 03:50:13" "21/10/2019 03:50:13"
"16" "show_roles" "web" "21/10/2019 03:50:57" "21/10/2019 03:50:57"
"17" "show_permisos" "web" "21/10/2019 03:51:37" "21/10/2019 03:51:37"
"18" "export_permisos" "web" "21/10/2019 03:53:25" "21/10/2019 03:53:25"
"19" "print_permisos" "web" "21/10/2019 03:54:00" "21/10/2019 03:54:00"
"20" "export_users" "web" "21/10/2019 03:54:50" "21/10/2019 03:54:50"
"21" "export_roles" "web" "21/10/2019 03:55:33" "21/10/2019 03:55:33"
"22" "print_users" "web" "21/10/2019 03:56:44" "21/10/2019 03:56:44"
"23" "create_menus" "web" "21/10/2019 04:09:24" "21/10/2019 04:09:24"
"24" "update_menus" "web" "21/10/2019 04:09:43" "21/10/2019 04:10:37"
"25" "read_menus" "web" "21/10/2019 04:11:02" "21/10/2019 04:11:02"
"26" "delete_menus" "web" "21/10/2019 04:11:23" "21/10/2019 04:11:23"
"27" "export_menus" "web" "21/10/2019 04:11:41" "21/10/2019 04:11:41"
"28" "print_menus" "web" "21/10/2019 04:11:56" "21/10/2019 04:11:56"
"29" "show_menus" "web" "21/10/2019 04:13:09" "21/10/2019 04:13:09"
"30" "create_menu-rol" "web" "21/10/2019 04:51:00" "21/10/2019 04:51:00"
"31" "read_menu-rol" "web" "21/10/2019 04:51:21" "21/10/2019 04:51:21"
"32" "update_menu-rol" "web" "21/10/2019 04:51:41" "21/10/2019 04:51:41"
"33" "delete_menu-rol" "web" "21/10/2019 04:52:00" "21/10/2019 04:52:00"
"34" "show_menu-rol" "web" "21/10/2019 04:52:19" "21/10/2019 04:52:19"
"35" "export_menu-rol" "web" "21/10/2019 04:52:36" "21/10/2019 04:52:36"
"36" "print_menu-rol" "web" "21/10/2019 04:53:04" "21/10/2019 04:53:04"
"37" "create_empresas" "web" "23/10/2019 19:14:10" "23/10/2019 19:14:10"
"38" "read_empresas" "web" "23/10/2019 19:14:45" "23/10/2019 19:14:45"
"39" "update_empresas" "web" "23/10/2019 19:15:05" "23/10/2019 19:15:05"
"40" "delete_empresas" "web" "23/10/2019 19:15:23" "23/10/2019 19:15:23"
"41" "show_empresas" "web" "23/10/2019 19:15:39" "23/10/2019 19:15:39"
"42" "export_empresas" "web" "23/10/2019 19:15:58" "23/10/2019 19:15:58"
"43" "print_empresas" "web" "23/10/2019 19:16:12" "23/10/2019 19:16:12"
"44" "create_cities" "web" "26/10/2019 03:51:43" "26/10/2019 03:53:37"
"45" "read_cities" "web" "26/10/2019 03:52:08" "26/10/2019 03:53:50"
"46" "update_cities" "web" "26/10/2019 03:53:23" "26/10/2019 03:53:23"
"47" "delete_cities" "web" "26/10/2019 03:54:19" "26/10/2019 03:54:19"
"48" "show_cities" "web" "26/10/2019 03:54:41" "26/10/2019 03:54:41"
"49" "export_cities" "web" "26/10/2019 03:54:59" "26/10/2019 03:54:59"
"50" "print_cities" "web" "26/10/2019 03:55:20" "26/10/2019 03:55:20"
"51" "create_locations" "web" "26/10/2019 05:13:56" "26/10/2019 05:13:56"
"52" "read_locations" "web" "26/10/2019 05:14:37" "26/10/2019 05:14:37"
"53" "update_locations" "web" "26/10/2019 05:16:22" "26/10/2019 05:16:22"
"54" "delete_locations" "web" "26/10/2019 05:16:45" "26/10/2019 05:16:45"
"55" "show_locations" "web" "26/10/2019 05:17:02" "26/10/2019 05:17:02"
"56" "export_locations" "web" "26/10/2019 05:17:27" "26/10/2019 05:17:27"
"57" "print_locations" "web" "26/10/2019 05:17:48" "26/10/2019 05:17:48"
"58" "create_departments" "web" "26/10/2019 17:43:41" "26/10/2019 17:43:41"
"59" "read_departments" "web" "26/10/2019 17:43:55" "26/10/2019 17:43:55"
"60" "update_departments" "web" "26/10/2019 17:44:24" "26/10/2019 17:44:24"
"61" "delete_departments" "web" "26/10/2019 17:44:38" "26/10/2019 17:44:38"
"62" "show_departments" "web" "26/10/2019 17:44:54" "26/10/2019 17:44:54"
"63" "export_departments" "web" "26/10/2019 17:45:10" "26/10/2019 17:45:10"
"64" "print_departments" "web" "26/10/2019 17:45:29" "26/10/2019 17:45:29"
"65" "create_bases" "web" "29/10/2019 04:22:37" "29/10/2019 04:22:37"
"66" "read_bases" "web" "29/10/2019 04:22:55" "29/10/2019 04:22:55"
"67" "update_bases" "web" "29/10/2019 04:23:11" "29/10/2019 04:23:11"
"68" "delete_bases" "web" "29/10/2019 04:23:28" "29/10/2019 04:23:28"
"69" "show_bases" "web" "29/10/2019 04:23:45" "29/10/2019 04:23:45"
"70" "export_bases" "web" "29/10/2019 04:24:01" "29/10/2019 04:24:01"
"71" "print_bases" "web" "29/10/2019 04:24:16" "29/10/2019 04:24:16"
"72" "restore_bases" "web" "29/10/2019 05:32:02" "29/10/2019 05:32:02"
"73" "restore_departments" "web" "29/10/2019 05:35:11" "29/10/2019 05:35:11"
"74" "restore_locations" "web" "29/10/2019 05:35:40" "29/10/2019 05:35:40"
"75" "restore_cities" "web" "29/10/2019 05:35:57" "29/10/2019 05:35:57"
"76" "restore_empresas" "web" "29/10/2019 05:36:17" "29/10/2019 05:36:17"
"77" "create_brands" "web" "30/10/2019 02:51:40" "30/10/2019 02:51:40"
"78" "read_brands" "web" "30/10/2019 02:51:56" "30/10/2019 02:51:56"
"79" "update_brands" "web" "30/10/2019 02:52:13" "30/10/2019 02:52:13"
"80" "delete_brands" "web" "30/10/2019 02:52:31" "30/10/2019 02:52:31"
"81" "show_brands" "web" "30/10/2019 02:52:48" "30/10/2019 02:52:48"
"82" "export_brands" "web" "30/10/2019 02:53:06" "30/10/2019 02:53:06"
"83" "print_brands" "web" "30/10/2019 02:53:23" "30/10/2019 02:53:23"
"84" "restore_brands" "web" "30/10/2019 02:53:55" "30/10/2019 02:53:55"
"85" "create_status-products" "web" "1/2/2020 07:27:51" "1/2/2020 07:27:51"
"86" "read_status-products" "web" "1/2/2020 07:28:28" "1/2/2020 07:28:28"
"87" "update_status-products" "web" "1/2/2020 07:28:44" "1/2/2020 07:28:44"
"88" "delete_status-products" "web" "1/2/2020 07:28:56" "1/2/2020 07:28:56"
"89" "show_status-products" "web" "1/2/2020 07:29:12" "1/2/2020 07:29:12"
"90" "export_status-products" "web" "1/2/2020 07:29:25" "1/2/2020 07:29:25"
"91" "print_status-products" "web" "1/2/2020 07:29:41" "1/2/2020 07:29:41"
"92" "restore_status-products" "web" "1/2/2020 07:29:53" "1/2/2020 07:29:53"
"93" "create_currencies" "web" "2/2/2020 05:08:55" "2/2/2020 05:16:11"
"94" "read_currencies" "web" "2/2/2020 05:09:28" "2/2/2020 05:16:01"
"95" "update_currencies" "web" "2/2/2020 05:09:50" "2/2/2020 05:15:48"
"96" "delete_currencies" "web" "2/2/2020 05:10:11" "2/2/2020 05:15:37"
"97" "show_currencies" "web" "2/2/2020 05:10:33" "2/2/2020 05:15:12"
"98" "export_currencies" "web" "2/2/2020 05:10:54" "2/2/2020 05:14:55"
"99" "print_currencies" "web" "2/2/2020 05:11:09" "2/2/2020 05:14:45"
"100" "restore_currencies" "web" "2/2/2020 05:11:26" "2/2/2020 05:14:33"
"101" "create_categories" "web" "2/2/2020 20:11:06" "2/2/2020 20:42:05"
"102" "read_categories" "web" "2/2/2020 20:11:30" "2/2/2020 20:41:49"
"103" "update_categories" "web" "2/2/2020 20:11:49" "2/2/2020 20:41:32"
"104" "delete_categories" "web" "2/2/2020 20:12:05" "2/2/2020 20:41:16"
"105" "show_categories" "web" "2/2/2020 20:12:50" "2/2/2020 20:41:00"
"106" "export_categories" "web" "2/2/2020 20:13:11" "2/2/2020 20:40:42"
"107" "print_categories" "web" "2/2/2020 20:13:28" "2/2/2020 20:40:27"
"108" "restore_categories" "web" "2/2/2020 20:13:45" "2/2/2020 20:40:09"
"109" "create_countries" "web" "3/2/2020 00:26:19" "3/2/2020 00:26:19"
"110" "read_countries" "web" "3/2/2020 00:26:32" "3/2/2020 00:26:32"
"111" "update_countries" "web" "3/2/2020 00:26:46" "3/2/2020 00:26:46"
"112" "delete_countries" "web" "3/2/2020 00:27:00" "3/2/2020 00:27:00"
"113" "show_countries" "web" "3/2/2020 00:27:13" "3/2/2020 00:27:13"
"114" "export_countries" "web" "3/2/2020 00:27:27" "3/2/2020 00:27:27"
"115" "print_countries" "web" "3/2/2020 00:27:41" "3/2/2020 00:27:41"
"116" "restore_countries" "web" "3/2/2020 00:27:56" "3/2/2020 00:27:56"
"117" "create_discounts" "web" "3/2/2020 05:40:03" "3/2/2020 05:40:03"
"118" "read_discounts" "web" "3/2/2020 05:40:16" "3/2/2020 05:40:16"
"119" "update_discounts" "web" "3/2/2020 05:40:32" "3/2/2020 05:40:32"
"120" "delete_discounts" "web" "3/2/2020 05:40:46" "3/2/2020 05:40:46"
"121" "show_discounts" "web" "3/2/2020 05:41:04" "3/2/2020 05:41:04"
"122" "export_discounts" "web" "3/2/2020 05:41:18" "3/2/2020 05:41:18"
"123" "print_discounts" "web" "3/2/2020 05:41:32" "3/2/2020 05:41:32"
"124" "restore_discounts" "web" "3/2/2020 05:41:48" "3/2/2020 05:41:48"
"125" "create_taxes" "web" "3/2/2020 06:11:47" "3/2/2020 06:11:47"
"126" "read_taxes" "web" "3/2/2020 06:12:04" "3/2/2020 06:12:04"
"127" "update_taxes" "web" "3/2/2020 06:12:19" "3/2/2020 06:12:19"
"128" "delete_taxes" "web" "3/2/2020 06:12:33" "3/2/2020 06:12:33"
"129" "show_taxes" "web" "3/2/2020 06:12:50" "3/2/2020 06:12:50"
"130" "export_taxes" "web" "3/2/2020 06:13:03" "3/2/2020 06:13:03"
"131" "print_taxes" "web" "3/2/2020 06:13:15" "3/2/2020 06:13:15"
"132" "restore_taxes" "web" "3/2/2020 06:13:29" "3/2/2020 06:13:29"
"133" "create_states" "web" "3/2/2020 20:25:03" "3/2/2020 20:25:03"
"134" "edit_states" "web" "3/2/2020 20:25:15" "3/2/2020 20:25:15"
"135" "update_states" "web" "3/2/2020 20:25:31" "3/2/2020 20:25:31"
"136" "read_states" "web" "3/2/2020 20:25:49" "3/2/2020 20:25:49"
"137" "delete_states" "web" "3/2/2020 20:26:07" "3/2/2020 20:26:07"
"138" "show_states" "web" "3/2/2020 20:26:25" "3/2/2020 20:26:25"
"139" "export_states" "web" "3/2/2020 20:26:42" "3/2/2020 20:26:42"
"140" "print_states" "web" "3/2/2020 20:26:56" "3/2/2020 20:26:56"
"141" "restore_states" "web" "3/2/2020 20:27:12" "3/2/2020 20:27:12"
"142" "create_unidades" "web" "4/2/2020 01:48:07" "4/2/2020 01:48:07"
"143" "read_unidades" "web" "4/2/2020 01:48:20" "4/2/2020 01:48:20"
"144" "update_unidades" "web" "4/2/2020 01:48:38" "4/2/2020 01:48:38"
"145" "delete_unidades" "web" "4/2/2020 01:48:54" "4/2/2020 01:48:54"
"146" "show_unidades" "web" "4/2/2020 01:49:09" "4/2/2020 01:49:09"
"147" "export_unidades" "web" "4/2/2020 01:49:23" "4/2/2020 01:49:23"
"148" "print_unidades" "web" "4/2/2020 01:49:39" "4/2/2020 01:49:39"
"149" "restore_unidades" "web" "4/2/2020 01:49:53" "4/2/2020 01:49:53"
"150" "create_sucursales" "web" "4/2/2020 03:03:08" "4/2/2020 03:03:08"
"151" "read_sucursales" "web" "4/2/2020 03:03:40" "4/2/2020 03:03:40"
"152" "update_sucursales" "web" "4/2/2020 03:04:15" "4/2/2020 03:04:15"
"153" "delete_sucursales" "web" "4/2/2020 03:04:31" "4/2/2020 03:04:31"
"154" "show_sucursales" "web" "4/2/2020 03:04:46" "4/2/2020 03:04:46"
"155" "export_sucursales" "web" "4/2/2020 03:05:02" "4/2/2020 03:05:02"
"156" "print_sucursales" "web" "4/2/2020 03:05:17" "4/2/2020 03:05:17"
"157" "restore_sucursales" "web" "4/2/2020 03:05:30" "30/1/2021 23:25:45"
"161" "restore_menus" "web" "2/2/2021 13:49:44" "2/2/2021 13:49:44"
"162" "read_discount_types" "web" "12/2/2021 23:13:11" "12/2/2021 23:13:11"
"163" "create_discount_types" "web" "12/2/2021 23:13:30" "12/2/2021 23:13:30"
"164" "show_discount_types" "web" "12/2/2021 23:13:51" "12/2/2021 23:13:51"
"165" "restore_discount_types" "web" "12/2/2021 23:14:10" "12/2/2021 23:14:10"
"166" "update_discount_types" "web" "12/2/2021 23:14:27" "12/2/2021 23:14:27"
"167" "delete_discount_types" "web" "12/2/2021 23:14:42" "12/2/2021 23:14:42"
"168" "print_discount_types" "web" "12/2/2021 23:44:57" "12/2/2021 23:44:57"
"169" "export_discount_types" "web" "12/2/2021 23:45:15" "12/2/2021 23:45:15"
"170" "read_sub-categories" "web" "13/2/2021 11:52:53" "13/2/2021 11:52:53"
"171" "create_sub-categories" "web" "13/2/2021 11:53:12" "13/2/2021 11:53:12"
"172" "show_sub-categories" "web" "13/2/2021 11:53:32" "13/2/2021 11:53:32"
"173" "restore_sub-categories" "web" "13/2/2021 11:53:50" "13/2/2021 11:53:50"
"174" "update_sub-categories" "web" "13/2/2021 11:54:08" "13/2/2021 11:54:08"
"175" "delete_sub-categories" "web" "13/2/2021 11:54:23" "13/2/2021 11:54:23"
"176" "print_sub-categories" "web" "13/2/2021 11:54:41" "13/2/2021 11:54:41"
"178" "view_users" "web" "6/1/2022 11:41:36" "6/1/2022 11:41:36"
"179" "restore_users" "web" "13/1/2022 10:02:50" "13/1/2022 10:02:50"
"180" "view_empresas" "web" "14/1/2022 10:46:42" "14/1/2022 10:46:42"
"181" "view_discounts" "web" "15/1/2022 23:00:49" "15/1/2022 23:00:49"
"182" "read_almacenes" "web" "20/1/2022 17:11:30" "20/1/2022 17:11:30"
"183" "create_almacenes" "web" "20/1/2022 17:12:00" "20/1/2022 17:12:00"
"184" "show_almacenes" "web" "20/1/2022 17:12:26" "20/1/2022 17:12:26"
"185" "restore_almacenes" "web" "20/1/2022 17:12:47" "20/1/2022 17:12:47"
"186" "update_almacenes" "web" "20/1/2022 17:13:15" "20/1/2022 17:13:15"
"187" "delete_almacenes" "web" "20/1/2022 17:13:38" "20/1/2022 17:13:38"
"188" "print_almacenes" "web" "20/1/2022 17:13:58" "20/1/2022 17:13:58"
"189" "export_almacenes" "web" "20/1/2022 17:14:24" "20/1/2022 17:14:24"
"190" "view_almacenes" "web" "20/1/2022 17:14:48" "20/1/2022 17:14:48"
"191" "administrar" "web" "20/1/2022 19:51:19" "20/1/2022 19:51:19"
"192" "store" "web" "20/1/2022 19:56:16" "31/1/2022 11:47:28"
"193" "read_suppliers" "web" "21/1/2022 15:29:05" "21/1/2022 15:29:05"
"194" "create_suppliers" "web" "21/1/2022 15:32:33" "21/1/2022 15:32:33"
"195" "show_suppliers" "web" "21/1/2022 15:32:49" "21/1/2022 15:32:49"
"196" "restore_suppliers" "web" "21/1/2022 15:33:04" "21/1/2022 15:33:04"
"197" "update_suppliers" "web" "21/1/2022 15:33:18" "21/1/2022 15:33:18"
"198" "delete_suppliers" "web" "21/1/2022 15:33:32" "21/1/2022 15:33:32"
"199" "print_suppliers" "web" "21/1/2022 15:33:52" "21/1/2022 15:33:52"
"200" "export_suppliers" "web" "21/1/2022 15:34:08" "21/1/2022 15:34:08"
"201" "view_suppliers" "web" "21/1/2022 15:34:27" "21/1/2022 15:34:27"
"202" "read_modules" "web" "30/1/2022 23:09:45" "30/1/2022 23:09:45"
"203" "create_modules" "web" "30/1/2022 23:10:14" "30/1/2022 23:10:14"
"204" "show_modules" "web" "30/1/2022 23:10:37" "30/1/2022 23:10:37"
"205" "restore_modules" "web" "30/1/2022 23:10:51" "30/1/2022 23:10:51"
"206" "update_modules" "web" "30/1/2022 23:11:04" "30/1/2022 23:11:04"
"207" "delete_modules" "web" "30/1/2022 23:11:22" "30/1/2022 23:11:22"
"208" "print_modules" "web" "30/1/2022 23:11:38" "30/1/2022 23:11:38"
"209" "export_modules" "web" "30/1/2022 23:11:52" "30/1/2022 23:11:52"
"210" "view_modules" "web" "30/1/2022 23:12:09" "30/1/2022 23:12:09"

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Select INNER JOIN obtener solo algunos registros
132
January 31, 2022 06:26PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.