Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
Structured Query Language (SQL) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS)
0
votes
1
answer
32
views
Combine 2 Booking Tables [closed]
ON a.Cust_Email = b.Email
Note: the 'ON a.Cust_Email = b.Email' part bothers me, it doesn't appear to interfere with the query however I don't actually want to include it, but can't validate/run the SQL …
1
vote
1
answer
234
views
Customer and Bookings DE - Save COUNT of Bookings in Customer DE?
I want to run an SQL Query Activity to count the number of Bookings that match against the customers Email address in the XYZ Bookings DE and save this into the XYZ Customers.Bookings_Count field. … Made an SQL query activity to save the total booking count & email address into the intermediate DE
select count (Cust_Email) as bookings, Cust_Email
from [XYZ Bookings] WHERE Cust_Email IS NOT NULL …