Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
load
*
where exists(QVField1, SQLField1) and exists(QVField2, SQLField2);
SQL select
*
From YourSQLDB;
Thanks that worked. I ended up using the where exists on a QVD (which I load overnite) after pulling the table from MySQL.