Hi guys I am trying to build a query through SQL and having some troubles. I dont use SQL at all but I am only left with this option in the application. In the application there has to be a certain line in every SQL command which is:
SELECT l.listing_id,l.messaging_id,l.name FROM listing l WHERE l.messaging_id IS NOT NULL
I have created this report in Crystal fine but it is a different query inside this application and is where I need it. Here is my SQL code for Crystal:
SELECT "ORG"."ORG_CODE", "LISTING"."NAME", "LISTING"."MESSAGING_ID", "LISTING"."EMPLOYEE_ID"
FROM "ATMS"."LISTING" "LISTING" INNER JOIN "ATMS"."ORG" "ORG" ON "LISTING"."ORG_SEQNUM"="ORG"."ORG_SEQNUM"
WHERE "ORG"."ORG_CODE" LIKE '060%'
ORDER BY "LISTING"."NAME"
Can someone help me combine the 2 codes I keep getting a too many values error.
Thanks!
Nick
SELECT l.listing_id,l.messaging_id,l.name, listing.messaging_ID, "ORG"."ORG_CODE", "LISTING"."EMPLOYEE_ID"
FROM listing l, "ATMS"."LISTING" "LISTING" INNER JOIN "ATMS"."ORG" "ORG" ON "LISTING"."ORG_SEQNUM"="ORG"."ORG_SEQNUM" WHERE l.messaging_id IS NOT NULL AND listing.messaging_ID = '27811'