Hi there, just need help with this query as I already have a table with data named ‘table2’ and I don’t know why an error message keeps popping up when I enter this code. I want to fetch the categories of information in one table to return results only for that when searched for and can’t seem to get past this issue as it isn't able to identify table2. If you could assist that would be great.
1 Like
Hello @jamesvenks!
Could you provide more details on the error? Are you able to rename the table to avoid the issue?
For your use case, you want to search table1 and then display category data from the results of the search in a second table?
Or are you running one query for table1, then on row selection, passing that information into a second query to populate the second table?