Skip to main content ↑ ↓
Topic: Error violation: 1052 Column 'no_pr' in where clause is ambiguous (Read 2130 times) previous topic - next topic

Error violation: 1052 Column 'no_pr' in where clause is ambiguous

Hi, i want to ask how you can make the detail table display more than 1 record, because here i click on the no_pr, which only shows 1 data record in the detail table, while the value no_pr has 2 detailed data records. thanks



my design is like this example:
master tables:
NoPR
00299

details table:
NoPR     Product
00299      A
00299      B
00299      C

this sample