topic MySQL query using Where in in QlikView

MySQL query using Where in

tjardine99 — Sat, 16 Nov 2024 05:11:57 GMT

I am trying to LOAD an extract from a table in MySQL using two fields from an existing table. The two fields are the primary key for the MySQL table. Any thoughts?

Re: MySQL query using Where in

neelamsaroha157 — Mon, 19 Nov 2018 19:16:25 GMT

Can you elaborate a more on your question...

Re: MySQL query using Where in

tjardine99 — Mon, 19 Nov 2018 19:22:49 GMT

A table in MySQL I am trying to extract has the primary key set to field1, field2. I have these fields in an existing table in QV. I want to extract the records from the MySQL table with only the values that are in the existing table already loaded. ex. code:

SQL

Select *

where field1, field2 in qv_tbl:field1, qv_tbl:field2;

Re: MySQL query using Where in

NZFei — Mon, 19 Nov 2018 20:15:57 GMT

load

where exists(QVField1, SQLField1) and exists(QVField2, SQLField2);

SQL select

From YourSQLDB;

Re: MySQL query using Where in

tjardine99 — Tue, 20 Nov 2018 22:02:53 GMT

Thanks that worked. I ended up using the where exists on a QVD (which I load overnite) after pulling the table from MySQL.