I have a simple JOIN question I was wondering if anyone else had run into this issue.
I have two tables and I want to show records from the first table only if the field "TAG" IS NOT in the second table.
My code seems to work, but when I try to sort on one of the columns or do a search for a particular item, it says "LOADING" and never returns. Am I doing that PHPRunner isn't liking? Is there a different way to achieve what I need?
Like I said, my code returns the correct data just gives me other issues. Using PHPRunner 5.3 (Build 7474)
Here is my code:
SELECT
tbl1.SERIAL_NUMBER,
tbl1.WORK_ORDER,
tbl1.TAG,
tbl1.MODEL_NUMBER,
tbl1.MODEL_DESC,
tbl1.TO_CITY,
tbl1.FROM_CITY,
tbl1.FROM_STATE,
tbl1.CLOSED_DATE,
tbl1.LAST_UPDATING_TECH,
tbl1.CUSTOMER_CODE,
tbl1.ADDRESS_1,
tbl1.STATUS,
tbl1.CUSTOMER_ID,
tbl1.FROM_SERV_SITE,
tbl1.FROM_ADDRESS_1
FROM tbl1
LEFT OUTER JOIN tbl2 ON tbl1.TAG = tbl2.TAG
WHERE (ISNULL(tbl2.TAG) = True)
ORDER BY tbl1.TAG
Any suggestions are greatly appreciated! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=16712&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
