Search (1 Viewer)

[zezo2021]

friends;

there is 2 table in this DB as an example
Category
Compay

I want on the Query to display the unique company Record

but When searching by Category the company related to the category appears



I will Search By Category
But Company Name must be a unique row

How can I do that

 

[Pat Hartman]

You are joining to the cat table but not selecting any columns from it. If you were to select the category, you would see why you are getting multiple rows for a company. There is no error. The query is performing as i would expect it to. YOU need to decide If you want category and if you don't, then don't join to the cat table.

Also, your design is flawed. This is implemented as a 1-many but it seems odd. I would expect the relationship to be many-many given the common English understanding of the word category. That means you need a third table. The cat table you have would be renamed to CompanyCat and a new Cat table would be defined with just the category. The PK of the CompanyCat would be a two column key with both Company and Cat selected so that the combination is unique.