选择一个共同的价值 [英] select a common value

问题描述

在我的数据库中有两个表category_table和sub_category表。

类别表-id，categoryname，类别状态

子类别表= id，subcategory_name，category id， subcategory_status





现在我想显示class_name，它应该使用ms访问权限作为categoryid。

解决方案

尝试：

  SELECT  categoryname  FROM  categoryTable  WHERE  id = 666 

尽我所知你的问题你有两个表，你想显示第二个表中的数据，其id也在第一个表中，是吗？如果是的话你就可以做到这一点

 SELECT category_name FROM SubCategory a IINER JOIN Category b ON a.ID = b.ID 

in my database there are two tables category_table and sub_category table.
category table- id,categoryname,category status
subcategory table=id,subcategory_name,category id,subcategory_status


now i want to display the category_name which should have id as categoryid using ms access.

解决方案

Try:

SELECT categoryname FROM categoryTable WHERE id=666

as much i have understood your question u have two tables and u want to show the data from second table whose id is in first table too, is it?? if yes you can do it simply

SELECT category_name FROM SubCategory a IINER JOIN Category b ON a.ID = b.ID

这篇关于选择一个共同的价值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！