**Answered** Getting a working Smart Query to work in ODBC

Anybody looking for a challenge?

My SQL Query Fu is weak and I'm trying to embed an SQL query in an Excel spreadsheet for use by users who are currently using a Smart Query. In the Smart Query the file is SODEL and the selection statement is this: WITH STATUS = "O" AND WITH BILL.CNO = "42632""42633""42626""42643"

The Smart Query returns what I want.

My SQL statement looks like this:

SELECT SALEDELV_NF.DELIVERY_KEY, SALEDELV_NF.S_ITEM_NBR, SALEDELV_NF.S_SCHED_DT, SALEDELV_NF.S_BAL_DUE, SALEDELV_NF.S_UM, SALEDELV_NF.S_SHIP_WHS, SALEDELV_PLANNER.PLANNER, SALEDELV_NF.S_WHS_OHQTY, SALEDELV_WORK_ORDERS.S_WIP_NBRS, SALEDELV_WORK_ORDERS.S_WIP_DUE_DT, SALEDELV_WORK_ORDERS.S_WIP_QTY_DU, SALEDELV_NF.S_BILL_NAME, SALEDELV_NF.STATUS, SALEDELV_NF.S_BILL_CNO

FROM SALEDELV_NF, SALEDELV_PLANNER, SALEDELV_WORK_ORDERS

WHERE SALEDELV_NF.ID = SALEDELV_PLANNER.ID AND SALEDELV_NF.ID = SALEDELV_WORK_ORDERS.ID AND (((SALEDELV_NF.S_BILL_CNO="42632") AND (SALEDELV_NF.STATUS="O")) OR ((SALEDELV_NF.S_BILL_CNO="42633") AND (SALEDELV_NF.STATUS="O")) OR ((SALEDELV_NF.S_BILL_CNO="42643") AND (SALEDELV_NF.STATUS="O")))

ORDER BY SALEDELV_NF.S_ITEM_NBR, SALEDELV_NF.S_SCHED_DT

The blank lines are for clarity. This statement, however, returns nothing.

Any ideas.