job-scrapper/querry.note

5 lines
187 B
Plaintext
Raw Permalink Normal View History

2024-06-13 09:14:04 +00:00
ATTACH Cantons.db AS Cantons
ATTACH 2.db AS db2
SELECT * FROM Jobs.jobs as b WHERE EXISTS (SELECT GDENAME FROM Cantons.cantons as w where w.GDEKT = 'ZH' AND b.location LIKE GDENAME);