Checking in two tables without a connection in a single query

[Meintrix]

I have 2 tables, but they are not connected. The tables are named linksistem and sira. They both have the following columns: int 11 for sira, varchar 10 for kisakod, varchar 100 for link, int 1 for durum, and varchar 100 for cid. In the linksistem table, there are also columns sira which is int 11, link which is varchar 100, durum which is int 1, and cid which is varchar 100.

Is there a way to check if the cid code exists in these tables with a single query?