SQL QUERY FORMULA ERROR

[Nadhirah]

Help me with the sql query please. Supposedly, only value of kategori asset under HT Switch Gear as it asset name will be shown to user for them to select.

The form should show all the related data to the HT Switch Gear when it is selected. I would use ref type for the HT Switch Gear but since for this particular form. I want it to show only available data for HT Switch Name (under asset name as column name). 

[Nadhirah]

Anyone have ideas on what formula to use?

[Suvrutt_Gurjar]

I think you may wish to mention your requirement with some more clarity.  Please state if more table names are involved relevant columns and then please state requirement with respect to that.

Generally, please assume that if you have not received a response  within a reasonable time, it means the requirement is probably not clear to the community.