25
Hi all,
I am using this Query in SSMS. I get a "Syntax Error" when I execute it.
My Query is listed below:
SELECT c.* FROM LogisticsPostalAddress a JOIN LogisticsLocation b ON a.LOCATION = b.PARENTLOCATION JOIN LOGISTICSELECTRONICADDRESS c ON b.recid = c.LOCATION WHERE a.RECID = PurchTable.DeliveryPostalAddress value;
What should I enter in values? Where can I find it?
Your statement is indeed syntactically wrong. What are you trying to achieve by "values"? If nothing, delete it. Also, you're trying to use PurchTable in a comparison, but you didn't select the table.
I think you should start by explaining what you're trying to achieve and why you're writing T-SQL in the first place.
Don't forget that if you access database directly, you must handle many things by yourself. For instance, you forgot to deal with DataAreaIds.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (