Help me out find the right formula!

hello everyone, i have a 3 diferend data (tables in airtable) data1, data2, data3.In each table (data) contains information about categories that are identical to each other (data1 - “sport”, data2 “sport”, data3 “sport”). Now I need a formula that will look in each of those 3 tables to see if it contains this category “sport” and show it in one place (like list of sport…)

SELECT(data.data1, item.fields.category==“Sport”)
SELECT(data.data2, item.fields.category==“Sport”)
SELECT(data.data3, item.fields.category==“Sport”)
How to combain this formulas togehter? or maybe i’m going about it completely wrong!

Can anyone help me please set up the formula?