Hi, I have a question about how to perform a Multiple LEFT JOIN, because I need to categorize certain ROWs of my TABLE A (all the fields always have information), based on the combination of criteria that I have in TABLE B, the categories are defined in the column RESPONSIBLE TEAM of TABLE B, many of the fields in TABLE B are empty and when this is the case, it is possible to select any value (wildcard), if I do a simple LEFT JOIN it works correctly, but I can't do more than two LEFT JOIN to be able to do the categorization I need.

I am using InlineQuerier.

this is what I am using:

select * from "TABLE A" 

LEFT JOIN "TABLE B"

on "Country" like "_Country"

and "State" like "_State" is not null or '%'

and "City" like "_City" is not null or '%'

and "CODE" like "_CODE" is not null or '%'

and "Description" like "_Description" is not null or '%'

and "Exp Comment" like "_Exp Comment" is not null or '%'

and "Condition" like "_Condition" is not null or '%'

and "User" like "_User" is not null or '%'

Could you take a look and help me with this, please?